桂林市城管委人员名单:Microsoft OLE DB Provider for SQL Server 错误 '80040e4d'

来源:百度文库 编辑:神马品牌网 时间:2024/05/05 09:54:32
Microsoft OLE DB Provider for SQL Server 错误 '80040e4d'

用户 'botye' 登录失败。

/bbs/CONN2.ASP,行 15
CONN2.ASP代码

<%
Dim dsnstr
'定义数据库类别,1为SQL数据库,0为Access数据库

Dim SqlDatabaseName,SqlPassword,SqlUsername,SqlLocalName
SqlDatabaseName="7878bbs"
SqlPassword="kingstone+bbs+1207good"
SqlUsername="sa"
SqlLocalName="127.0.0.1"

Dim ConnStr
ConnStr = "Provider=Sqloledb; User ID=" & SqlUsername & "; Password=" & SqlPassword & "; Initial Catalog = " & SqlDatabaseName & "; Data Source=" & SqlLocalName & ";"
Set dsnstr = Server.CreateObject("ADODB.Connection")
dsnstr.open ConnStr
If Err Then
err.Clear
Set dsnstr = Nothing
Response.Write "数据连接错误!"
Response.End
End If
set rs=server.CreateObject("adodb.recordset")

%>

My god