應該是OLEDB與ODBC連接方式的區別吧. 用sql server為例 ODBC: DIM Cn As New ADODB.Connection CN.OPEN "DRIVER={SQL SERVER};SERVER=SERVERNAME;UID=sa;PWD=password;DATABASE=databasename"OLEDB: DIM Cn As New ADODB.Connection cn.open "provider=sqloledb;data source=server name;initial catalog=databasename;uid=sa"
用sql server為例
ODBC:
DIM Cn As New ADODB.Connection
CN.OPEN "DRIVER={SQL SERVER};SERVER=SERVERNAME;UID=sa;PWD=password;DATABASE=databasename"OLEDB:
DIM Cn As New ADODB.Connection
cn.open "provider=sqloledb;data source=server name;initial catalog=databasename;uid=sa"