sql连接老是出错,大虾看看这两种写法对不?
SQL数据KK;
文件在:C:\KK_DATA.MDF
表:TT
1.
set cn=server.createobject("adodb.connection")
cn.open "driver={sql server};server=127.0.0.1;database=TT;UID=;PWD="
2.
set cn=server.createobject("adodb.connection")
cn.open "provider=sqloledb;data source=127.0.0.1;initial catalog=TT;user id=;password="
其中关键词:
server与data source;database与initial catalog;uid与user if;pwd与password可否掉换