Hi,
I'm trying to connect to an SQL server using the following script:
DSN = "DSN=Burn";
Conn = Server.CreateObject("ADODB.Connection"
Conn.Open(DSN);
But keep getting the error msg:
Login failed- User: Reason: Not associated with a trusted SQL Server connection.
I know that my ODBC settings are correct as I use these for normal SQL scripting every day with no problems and the data source tests sucessfully. Could somebody please tell me what I'm doing wrong
I'm trying to connect to an SQL server using the following script:
DSN = "DSN=Burn";
Conn = Server.CreateObject("ADODB.Connection"
Conn.Open(DSN);
But keep getting the error msg:
Login failed- User: Reason: Not associated with a trusted SQL Server connection.
I know that my ODBC settings are correct as I use these for normal SQL scripting every day with no problems and the data source tests sucessfully. Could somebody please tell me what I'm doing wrong