Visual Interdev and ODBC errors

Visual Interdev and ODBC errors

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?

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.

Share the Post:
data observability

Data Observability Explained

Data is the lifeblood of any successful business, as it is the driving force behind critical decision-making, insight generation, and strategic development. However, due to its intricate nature, ensuring the

Heading photo, Metadata.

What is Metadata?

What is metadata? Well, It’s an odd concept to wrap your head around. Metadata is essentially the secondary layer of data that tracks details about the “regular” data. The regular