Provider=MSDASQL; --ado connection provider type
Trusted_Connection=Yes; --security authentication model
Data Source=local;--SQL SERVER name
catalog=sampledb --database nameif YOU want connection to MSSQL SERVER ,you can try:
Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist Security Info=False;User ID=sa;Initial Catalog=database name;Data Source=server name;
Trusted_Connection=Yes; --security authentication model
Data Source=local;--SQL SERVER name
catalog=sampledb --database nameif YOU want connection to MSSQL SERVER ,you can try:
Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist Security Info=False;User ID=sa;Initial Catalog=database name;Data Source=server name;
strCN="Driver={SQL Server};Server=服务器名;DataBase=数据库;UID=用户;PWD=口令;"
eg:SQL服务器名为 WEBSVR,数据库名为WebMis(在SQL Enterprise Manager中查看到),用户sa,口令123,则以上为:
dim cn as adodb.connection
set cn =new adodb.connection
dim strCn as string
strCN="Driver={SQL Server};Server=WEBSVR;DataBase=WebMis;UID=sa;PWD=123;"
cn.open strCN