怎样编程ODBC配制数据源，而不用用户自己设置，给个原代码

Question

写好相应的数据库连接字符串即可,用户就不需要再配置
数据库连接字符串具体参考
http://www.connectionstrings.com/

Answer 1

SQL Server 
 ODBC 
 Standard Security:"Driver={SQL Server};Server=Aron1;Database=pubs;Uid=sa;Pwd=asdasd;"  Trusted connection:"Driver={SQL Server};Server=Aron1;Database=pubs;Trusted_Connection=yes;"  Prompt for username and password:oConn.Properties("Prompt") = adPromptAlways
oConn.Open "Driver={SQL Server};Server=Aron1;DataBase=pubs;" 

Answer 2

有个delphi的，参考参考http://huasky.muicc.com/jiaocheng_info.asp?jcname=569

Answer 3

SQL Server 
 ODBC 
 Standard Security:"Driver={SQL Server};Server=Aron1;Database=pubs;Uid=sa;Pwd=asdasd;"  Trusted connection:"Driver={SQL Server};Server=Aron1;Database=pubs;Trusted_Connection=yes;"  Prompt for username and password:oConn.Properties("Prompt") = adPromptAlways
oConn.Open "Driver={SQL Server};Server=Aron1;DataBase=pubs;"