示如下:
错误类型:
Microsoft OLE DB Provider for ODBC Drivers (0x80040E4D)
[Microsoft][ODBC SQL Server Driver][SQL Server]用户 'DAA5DDA31197484IUSR_DAA5DDA31197484' 登录失败。
/myasp/111.asp, 第 8 行
我的连接SQL Server数据库代码
<%
Dim Recordset1
Dim Recordset1_numRows
Set Recordset1 = Server.CreateObject("ADODB.Recordset")
Recordset1.ActiveConnection = MM_yuangongid_STRING
Recordset1.Source = "SELECT * FROM dbo.main ORDER BY id ASC"
Recordset1.CursorType = 0
Recordset1.CursorLocation = 2
Recordset1.LockType = 1
Recordset1.Open()
Recordset1_numRows = 0
%>
conn.asp
<%
' FileName="Connection_odbc_conn_dsn.htm"
' Type="ADO"
' DesigntimeType="ADO"
' HTTP="false"
' Catalog=""
' Schema=""
Dim MM_yuangongid_STRING
MM_yuangongid_STRING = "dsn=yuangong;"
%>