Forum Moderators: open
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?