You are viewing a plain-jane printable version of http://CoverYourASP.com/ADO2.asp.
See how this was done

 

Data source name not found.


MSDN references: Q174655 Q190006 Q159682 Q184572 Q173742 Q172864 Q251254

Very rare - in fact I've only been asked about this one twice. But it was such a difficult one to track down that it had to be documented - see above what a search on MSDN revealed!

The basic issue is that the database provider specified cannot be found. In my code, that's the sDBDriver variable located in include/config.asp, as shown below:

// ============================================
// database configuration
// ============================================

// OLE DB Provider constants
var sAccess9x = 'Microsoft.Jet.OLEDB.2.5';
var sAccess97 = 'Microsoft.Jet.OLEDB.3.51';
var sAccess2000 = 'Microsoft.Jet.OLEDB.4.0';
var sSQLServer = 'SQLOLEDB.1';

// which am I using?
var sDBDriver = sAccess97;

But as you can see from browsing the MSDN issues, that might be related to a global.asa or permission problem.

As a matter of course with database problems, always download the latest versions of the free Microsoft Data Access Components from http://www.microsoft.com/data/download.htm.

Windows 95 users - please note that you must install DCOM first, as described on the above microsoft page.

One last caveat. One of my readers had this problem, and it was finally solved in a different way. Here are his words:

"Just to let you know that I managed to fix the problem. I think it had something to do with the permissions on the winnt/temp/ folder - if that makes any sense. I can't recreate the problem even if I remove all the permissions from that folder, but all I know is it is working now after I played with the system environment variables for the TMP and TEMP variable and adjusted the permissions on the temp folder. I think it was a bit of a bug, because it isn't standard behaviour." S.F.

Actually S.F., this is documented, but not as a "Data source not found" issue - see Q251254