Question:
I developed a very tiny project in Visual Interdev:
* Made a connection in de 32-bit ODBC (Control panel) with the Access97 Database and DSN name.
* Add data connection (an Access97 SR-1 database).
* Create the 3 forms with the data form wizard.
In Data View I can view the tables and views of the database, but When I want to Preview the ASP (The xxxxxxList.asp) I got an ODBC error:
Microsoft OLE DB Provider for ODBC Drivers error ‘80004005’
[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified /SBSReports/SBSDownTimeList.asp, line 185
I have installed Windows95 (OEM version with USD support, Frontpage98, Office97 SR-1, and Visual Interdev 1.0) in this order.Do I have the wrong ODBC drivers?
Answer:
It looks like your Web server and your Visual InterDev application “see” the database path differently. For instance, it’s possible that Visual InterDev is finding the workstation copy of the database on your client machine in c:programfilesDevStudioMyProjectsdbprojmydata.mdb. However, the client path makes no sense to the Web server. Internet Information Server probably needs to look for the database in c:inetpubwwwrootdbprojmydata.mdb.
One way to test this is to hardcode the path to the database in your global.asa file, such as:Session(“DataConn_ConnectionString”) = “DBQ=c:inetpubwwwrootdprojmydata.mdb;DefaultDir=c:inetpubwwwrootdbpro;Driver={Microsoft Access Driver (*.mdb)};DriverId=25;FIL=MS Access;ImplicitCommitSync=Yes;MaxBufferSize=512;MaxScanRows=8;PageTimeout=5;SafeTransactions=0;Threads=3;UID=admin;UserCommitSync=Yes;”
When you save and close the global.asa file, Visual InterDev will try to make the connection and fail. Just cancel the error message dialog box. When you run your xxxxxxList.asp script, the Web server will find the database and display the data as expected.
