Microsoft][ODBC SQL Server Driver][SQL Server]用户 'sa' 登录失败

[muqun]

下面的错误应该在怎么改。谢谢
Microsoft OLE DB Provider for ODBC Drivers 错误 '80040e4d'

[Microsoft][ODBC SQL Server Driver][SQL Server]用户 'sa' 登录失败。

/inc/check.asp，行11

下面为11行的内容
Dim dbConnect,objConn

dbConnect = "DRIVER={sql server};UID=sa;PWD=bettertomorrow;server=(local);database=BoifOffice"

'---- 打开数据库连接
Sub OpenConnection()
Set objConn = Server.CreateObject("ADODB.Connection")
objConn.Open dbConnect
End Sub

[007james]

参考下：
<%
dim conn
set conn=server.createobject("ADODB.connection")
con.open "PROVIDER=SQLOLEDB;DATA
SOURCE=SQL服务器名称或IP地址;UID=sa;PWD=数据库密码;DATABASE=数据库名称
%>

建立记录集对象：

set rs=server.createobject("adodb.recordset")
rs.open SQL语句,conn,3,2

[csdn88net]

<%
set objConn =server.CreateObject ("adodb.connection")
objConn.Open "driver={SQL Server};server=(local);uid=sa;password=bettertomorrow;database=BoifOffice"
%>

[wangwm]

应将定义的参数放在函数体内

Sub OpenConnection()
Dim dbConnect,objConn

dbConnect = "DRIVER={sql server};UID=sa;PWD=bettertomorrow;server=(local);database=BoifOffice"

Set objConn = Server.CreateObject("ADODB.Connection")
objConn.Open dbConnect
End Sub

[yzwxjun]

另外建一个用户，不要用SA登录，因为这个SA经常出毛病，还有就是你那条链接语句，改成下面这条
dbconnect = "provider=sqloledb;data source=服务器; initial catalog=数据库;user id=用户;password=密码"