ODBC connection/authentication problem using ASP
Posted on 2003-03-27
I have created a database in SQL Server and am trying to connect to it via ODBC DSN. I have created a DSN and have set it to use Windows Authentication rather then SQL authentication.
I set the default database to one i created and test the connection. The Test proves successful.
I have setup IIS to also use Windows Authentication, and requests to ASPs in my application without database access work fine.
But when ever a page uses the connection string to access the database it reports:
"Invalid object Name 'accessRights'", where accessRights is the name of one of the tables.
I am using the following connection string to access the DSN connection:
strConn = "DSN=myDSN"
Set objConn = Server.CreateObject("ADOBD.Connection")
I then use a simple Select statement to retrieve a recordset, but i get the error message.
"SELECT * FROM accessRights;"
Can anyone help?