Visual Interdev and ODBC errors

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.

Share the Post:
Share on facebook
Share on twitter
Share on linkedin

Overview

The Latest

homes in the real estate industry

Exploring the Latest Tech Trends Impacting the Real Estate Industry

The real estate industry is changing thanks to the newest technological advancements. These new developments — from blockchain and AI to virtual reality and 3D printing — are poised to change how we buy and sell homes. Real estate brokers, buyers, sellers, wholesale real estate professionals, fix and flippers, and beyond may

man on floor with data

DevX Quick Guide to Data Ingestion

One of the biggest trends of the 21st century is the massive surge in internet usage. With major innovations such as smart technology, social media, and online shopping sites, the internet has become an essential part of everyday life for a large portion of the population. Due to this internet

payment via phone

7 Ways Technology Has Changed Traditional Payments

In today’s digital world, technology has changed how we make payments. From contactless cards to mobile wallets, it’s now easier to pay for goods and services without carrying cash or using a checkbook. This article will look at seven of the most significant ways technology has transformed traditional payment methods.