创建odbcconnection的连接字符串或 ODBC 数据源名称 (DSN)是什么，这些字符串应怎么写啊？

[zzddl]

创建odbcconnection的连接字符串或 ODBC 数据源名称 (DSN)是什么，这些字符串应怎么写啊？

[strawwan]

http://dev.csdn.net/develop/article/16/16437.shtm
http://www.connectionstrings.com/

[allen1981813]

http://www.connectionstrings.com/
好地方啊。。。。

[yungboy]

ODBC 连SQL Server


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;"

ODBC 连Access



Standard Security:
"Driver={Microsoft Access Driver (*.mdb)};Dbq=\somepath\mydb.mdb;Uid=Admin;Pwd=asdasd;"


Workgroup:
"Driver={Microsoft Access Driver (*.mdb)};Dbq=\somepath\mydb.mdb;SystemDB=\somepath\mydb.mdw;","admin", ""