【求救】[DBNETLIB][ConnectionOpen (Connect()).]SQL Server 不存在或拒绝访问。
系统是ASP+SQL Sever 本机既作服务器又作客户机 出现这个问题
Microsoft OLE DB Provider for SQL Server '80004005'
[DBNETLIB][ConnectionOpen (Connect()).]SQL Server 不存在或拒绝访问。
\conn1.asp, line 42
--------------------------------------------------------------------------------
Host by NetBox Version 2.8 Build 4128
那个coon1.asp相应代码
Dim sql_databasename,sql_password,sql_username,sql_localname
sql_localname = "127.0.0.1"
sql_databasename = "bs"
sql_username = "sa"
sql_password = ""
connstr = "Provider = Sqloledb; User ID = " & sql_username & "; Password = " & sql_password & "; Initial Catalog = " & sql_databasename & "; Data Source = " & sql_localname & ";"
Set conn = Server.CreateObject("ADODB.Connection")
conn.open connstr
另外我发现这个问题会出现在拔出网络电缆的时候,在联网的情况下可以正常运行。
怎么解决啊~求助啊~万分感谢啊~~~