CONN.OPEN(="Provider=MSDataShape.1;) 执行失败
elxsw 2014-09-23 03:35:56 dim sql1 as string ,sql2 as string
dim conn1 as new adodb.connection,conn2 as new adodb.connection2
sql1="Provider=SQLOLEDB.1;Persist Security Info=False;User ID=sa;Password=123456;Initial Catalog=sj;Data Source=192.168.0.22\SQLSERVER,1433"
sql2="Provider=MSDataShape.1;Persist Security Info=False;User ID=sa;Password=123456;Initial Catalog=sj;Data Source=192.168.0.22\SQLSERVER,1433"
Conn1.CursorLocation = adUseClient
Conn2.CursorLocation = adUseClient
Conn1.Open (sql1) '此处执行没有问题
Conn2.Open (sql2) '此处执行出现以下错误提示:
[Microsoft][ODBC 驱动程序管理器] 未发现数据源名称并且未指定默认驱动程序
请问是何原因?