Forum Moderators: open

Message Too Old, No Replies

COnnection issues

I need help

         

UnderScore

5:02 pm on Mar 27, 2003 (gmt 0)

10+ Year Member



when I go to login I get this error

Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80040E4D)
[Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server connection.
/isnc/login.asp, line 31

here is the code
set objConn=Server.CreateObject("ADODB.Connection") 'create Connection
strCS="Driver={SQL Server};Server=AOPENSERVER;Database=ISNC;UID=user;PWD=user;"
objConn.ConnectionString=strCS
LINE 31objConn.Open "MyDSN" 'open connection using System DSN

now the connection MyDSN is right and if I change it then I get a different error, but if I change anything in the connection string(line 30) it has no effect on the error. Any thoughts?

korkus2000

2:48 am on Mar 29, 2003 (gmt 0)

WebmasterWorld Senior Member 10+ Year Member



Try adding this to your connection string Trusted_Connection=yes;