ABODB.Connection error '800a07a', How to fix this error?

Asked Jun 30 '14 at 18:14

Active Jul 01 '14 at 07:53

Viewed 185 times

I'm having issues with an ASP page that needs to connect to Access. I am getting the following error message:

Provider cannot be found. It may not be properly installed.

I have researched and googled the solution but it does not work. I have tried to change the application pool settings to Classic ASP and allow to use 32 bit applications, but when I switch it from 64 bit to 32 bit, the application pool automatically stops and I get an 503 error and the webpage does not show up. If I switch it back to 64 bit I get my original error.

Here is the connection string:

set conn=Server.CreateObject("ADODB.Connection")
conn.provider="Microsoft.Jet.OLEDB.4.0;"
conn.open server.mappath("databases/Phone_Directory.mdb")

edited Jul 01 '14 at 07:53

Shadow The GPT Wizard

66,030
26
140
208

asked Jun 30 '14 at 18:14

user3791338

try finding a solution here: http://stackoverflow.com/questions/4665114/how-do-i-run-classic-asp-with-jet-oledb-4-0-in-64bit-windows-7 – Daniel A. White Jun 30 '14 at 18:52
You may also find some useful suggestions [here](http://stackoverflow.com/q/637326/2144390). – Gord Thompson Jun 30 '14 at 20:54
1

What IIS version? What OS? – Shadow The GPT Wizard Jul 01 '14 at 07:53
1

Also, try creating DSN via ODBC. Not good practice, but it might work. – Shadow The GPT Wizard Jul 01 '14 at 07:53
I presume that you're running on a 64bit version of Windows? Try this question: http://stackoverflow.com/questions/24416688/architecture-mismatch-between-32-bit-and-64-bit-odbc-drivers – Andy Davies Jul 01 '14 at 11:27
I believe is 7.0. Thanks so much for everyone's help – user3791338 Jul 01 '14 at 20:03
still cant get to work – user3791338 Jul 02 '14 at 21:09

ABODB.Connection error '800a07a', How to fix this error?

0 Answers0