I have created a web application that uses ASP on the front end, which calls
VB functions that read and write to an Access database.
Everything works great when the VB DLL is in run mode, but after it is
compiled, I am getting the following message in the Event Viewer when trying
to connect to the Access database via ODBC:
"Data source name not found and no default driver specified from Microsoft
OLE DB Provider for ODBC drivers."
I have already created the ODBC data source (under System DSN).
Here is the relevant code from the DLL:
Dim Conn As ADODB.Connection
Set Conn = New ADODB.Connection
Conn.Open "webdb" //////////this is where it is blowing up