asp与sql server的连接

daring 发布于 2006-10-09 17:54， 700 次点击

<%
dim cnn
Set Cnn = Server.CreateObject("ADODB.Connection")

cnn.connectionstring="driver={sql server};server=xiaozhen; UID=sa;PWD=sa;DATABASE=findsystem"
Cnn.Open
if cnn.state=1 then
response.write "连接成功"
end if
%>

错误提示:服务器对象错误'asp 0177 :8007007f'
server.createobject 失败

2 回复

jimn20002006-10-09 20:17

<%
dim cnn
Set Cnn = Server.CreateObject("ADODB.Connection")

cnn.connectionstring="driver={sql server};server=xiaozhen; UID=sa;PWD=sa;DATABASE=findsystem"
Cnn.Open
if cnn.state=1 then
response.write "连接成功"
end if
%>
server.createobject 失败

看看我的网站

www.helpsos.cn