关于用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
%>