郑委讲座视频:Microsoft OLE DB Provider for SQL Server 错误 '80040e4d'

来源:百度文库 编辑:杭州交通信息网 时间:2024/05/02 20:43:54
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