<connectionStrings>
<add name="TEST2006ConnectionString" connectionString="Data Source=localhost;Initial Catalog=TEST2006;Integrated Security=True"
providerName="System.Data.SqlClient" />
</connectionStrings>
可以连接conn.ConnectionString = "PROVIDER=SQLoledb;Data Source=localhost;Initial Catalog=TEST2006;Integrated Security=True"
conn.ConnectionTimeout = 0
conn.Open
没反应。谢谢
<add name="TEST2006ConnectionString" connectionString="Data Source=localhost;Initial Catalog=TEST2006;Integrated Security=True"
providerName="System.Data.SqlClient" />
</connectionStrings>
可以连接conn.ConnectionString = "PROVIDER=SQLoledb;Data Source=localhost;Initial Catalog=TEST2006;Integrated Security=True"
conn.ConnectionTimeout = 0
conn.Open
没反应。谢谢
"Driver={SQL Native Client};Server=Aron1;Database=pubs;UID=sa;PWD=asdasd;" OLEDB
"Provider=SQLNCLI;Server=Aron1;Database=pubs;UID=sa;PWD=asdasd;"
conn.ConnectionTimeout = 0
conn.Open
不行,出现:
多步 OLE DB 操作产生错误。如果可能,请检查每个 OLE DB 状态值。没有工作被完成。
set objConn=server.CreateObject("adodb.connection")
objConn.Open "Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=数据库名称;Data Source=机器名"
Set RS1=objConn.Execute("select * from t1")
if not RS1.eof then
response.write "ok"
end if
RS1.close
set RS1=nothing%>