I'm trying to connect to a Pervasive 9.5 database using classic asp, and
am getting error messages establishing the connection. I'm getting the
same error messages with DEMODATA as I am with our custom database.

This code:

dim objconn
set objconn = server.createobject("ADODB.Connection")
objconn.connectionstring = "DSN=DEMODATA"
objconn.open

gives this error message:

Microsoft OLE DB Provider for ODBC Drivers error '80004005'
Specified driver could not be loaded due to system error 5 (Pervasive
ODBC Engine Interface).


If I specify the provider:

dim objconn
set objconn = server.createobject("ADODB.Connection")
objconn.connectionstring = "DSN=DEMODATA"
objconn.provider = "Pervasive ODBC Engine Interface"
objconn.open

I get this error:

ADODB.Connection error '800a0e7a'
Provider cannot be found. It may not be properly installed.


The thing is, the DEMODATA and the custom datasource both work fine on
the machine. The "Test" button in ODBC Setup works fine, I can connect
to the data sources just fine via ODBC with Crystal Reports, etc. So,
the Pervasive odbc driver is working fine. Is there a different one for
IIS though?

I can also connect to non-Pervasive ODBC DSNs just fine using ASP.

I've made sure IUSR has full-control permissions for the data files and
all parent folders. I've updated MDAC to the latest version. I've
restarted the Web site and the whole machine. What else can I try?

Thanks,

ERR - OLEDB Error 80004005, Specified Driver Could Not Be Loaded Due To
System Error 5
Application: OLEDB / IIS
Version: Any
Platform: IIS / Win2K
Engine: PSQLv8.0

Issue:
Attempts to open an ODBC connection to a Pervasive v7, 2000i, or v8
database from script in an ASP page on an Microsoft IIS v5 web server
(Win2000) fail with the following error under v8:
Microsoft OLE DB Provider for ODBC Drivers error '80004005'
Specified driver could not be loaded due to system error 5 (Pervasive
ODBC Client Interface).

The error is thrown when the ASP interpreter attempts to execute the
conn.open line.

Under v7, second line of the error may be:
Specified driver could not be loaded due to system error 126
(Pervasive Software ODBC-32)
or:
[Pervasive Software][ODBC Interface][Pervasive Software SQL
Engine]General error.

(Other versions of Pervasive and IIS may be similarly affected, but
have not been tested in relation to this issue. This issue first
reported by a user whose working system broke when migrated from
NT4-IISv4 to W2k-IISv5.)

Resolution:
The IUSR_webserverhostname login account needs to have Read & Execute
permissions to the C:\PVSW\bin directory on the web server. You may
need to restart IIS or the whole server for changes in these
permissions to take effect.

Microsoft KB articles 175671 and 306518 discuss 80004005 errors, but
don't point clearly to this exact permissions requirement.

HTH...
Goldstar Software Inc.
Pervasive-based Products, Training & Services
Bill Bach
BillBach (AT) goldstarsoftware (DOT) com
http://www.goldstarsoftware.com
*** Chicago: Pervasive Service & Support Class - 03/2007 ***


Mark wrote: