I'm setting up a database connection on my web site (IIS 4.0) using
Visual InterDev. [InterDev runs on a development machine] The
database is in MS SQL Server 7.0 and is located on a different machine
than the web server.
In SQL server I have created 2 logins WebAdmin and WebUser. I have
also created 2 DSN's on the InterDev machine - one for WebAdmin and
one for WebUser using the ODBC found in the Control Panel.
I have 2 connections to my SQL database one using WebAdmin and one
My code uses a SELECT statement to retrieve records from a table.
The code using the WebAdmin works and retrieves the records. The code
using WebUser generates an error: ODBC Drivers error '80040e37' ...
Invalid object name ...
What am I doing wrong?