This topic has been archived. It cannot be replied.
-
工作学习 / IT技术讨论 / one asp problemi use the following codes to connect to SQL2000:
Set Myconn=Server.CreateObject("ADODB.Connection")
Myconn.Open "DSN=testdsn; uid=bill; pwd="
because i use the mode of windows NT Authentication, I don't need user id and password. the error is:
Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80040E4D)
[Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user 'BENIX-DEV\IUSR_ACCESS-I0I72DPZ'.
/benix/testdatabase.asp, line 9
who can tell me what's the reason
-jpbillzhou(chineseman);
2003-10-14
{501}
(#1412098@0)
-
如果你用NT authentication，try to add 'Integrated Security=SSPI' in your connection string.
-luoboyang(萝卜秧);
2003-10-14
(#1412109@0)
-
can you write the code for me? thanks a lot
-jpbillzhou(chineseman);
2003-10-14
(#1412139@0)