关于用ODBC联sql2000的问题
我采用ODBODBC联sql2000，如下 ：
<%
Set dbCon = Server.CreateObject( "ADODB.Connection ")
dbCon.Open "jing3 ", " ", " "
set dbRS=dbCon.Execute( " SELECT * FROM qtxl order by area,dep ")
%>
出错提示如下：
[Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user 'AAA123\IUSR_AAA123 '.
AAA123是计算机名。
[解决办法]
给你个例子吧：
<% '建立连接
dim conn
Set conn=Server.CreateObject( "ADODB.Connection ")
conn.ConnectionTimeout=20
conn.open "driver={SQL Server};server=localhost;uid=sa;pwd=sa;database=ExamRun "
Sub CloseDb()
If Conn.State = 1 Then
Conn.Close
End If
Set Conn = Nothing
End Sub
%>
