使用SQL 2000 安装网站，打开网页显示错误 '80004005' SQL Server 不存在或访问被拒绝

显示全部楼层 · 2010-11-20 22:15:29

使用SQL 2000 安装网站，打开网页显示
Microsoft OLE DB Provider for ODBC Drivers 错误 '80004005'
[Microsoft][ODBC SQL Server Driver][DBMSLPCN]SQL Server 不存在或访问被拒绝
/IISHelp/a/DataBase/conn.asp，行 4
conn.asp
---------------------------------
")

fString = Replace(fString, CHR(10), "
")
fString = Replace(fString, CHR(32), " ")

HTMLcode = fString
end if
end function
%>

千问 · 2010-11-20 22:15:29

Path="driver={SQL Server};server=156253EA2A8C403\SA.;uid=sa;pwd=sa;database=db_Car"把path变量换成下边的这个形式。sqlIP = "(local)"
'//数据库IP
sqlID = "sa"
'//数据库用户名
sqlPD = ""
'//数据库用户密码
sqlNM = "ayeSqlData" '//数据库名称
Path = "Provider = Sqloledb; User ID = " & sqlID & "; Password = " & sqlPD & "; Initial

千问 · 2010-11-20 22:15:29

server=156253EA2A8C403\SA 后面加上实例名试试