[DBNETLIB][ConnectionOpen (Connect()).]SQL Server 不存在或拒绝访问。
<%
dim conn, SerID, DbName, UserName, PassWord
SerID = "192.92.6.3"
DbName = "CLXH"
UserName = "11"
PassWord = "22"
sub ConnSqlSer
dim StrSqlConn
strsqlConn = "Provider=SQLOLEDB.1;Password=2736564;Persist Security Info=True;User ID=11;Initial Catalog=CLXH;Data Source=ta6ksql;Use Procedure for Prepare=1;Auto Translate=True;Packet Size=4096;Workstation ID=BILLGATES;Use Encryption for Data=False;Tag with column collation when possible=False"
set conn = server.CreateObject("adodb.connection")
conn.open strsqlconn
end sub
function CloseConn
conn.close
set conn = nothing
end function
%>
运行的时候提示如下:
Microsoft OLE DB Provider for SQL Server 错误 '80004005'
[DBNETLIB][ConnectionOpen (Connect()).]SQL Server 不存在或拒绝访问。
/kwxx/clxh/open.asp,行 12
请问大家是哪里写错了吗?应该如何修改?原来还好好的,sql 数据库重新安装以后就出现问题了!