Getting Error 800a0e7a "Provider cannot be found. It may not be properly installed."

asp-classic
Skrilliam picture Skrilliam · Feb 12, 2014 · Viewed 116.3k times · Source

So I am going back to a project I created in College, so I can transfer it to PHP. I orginally coded it in ASP Classic.

I am on Windows 8 and running Access 2013.

I am currently getting the following error

ADODB.Connection error '800a0e7a' Provider cannot be found. It may not be properly installed. /PROJECT!Better/verifyuser.asp, line 11

and this is my connection string code.

Dim vPath, pPath, Conn

vPath = ".\db\Comic.accdb"
pPath = Server.MapPath( vPath )

objConn = "PROVIDER=Microsoft.ACE.OLEDB.12.0;DATA SOURCE=" & pPath & ";"
Set Conn = Server.CreateObject("ADODB.Connection")
Conn.Open objConn

any help that you can provide would be awesome!

edit: I already have the enable 32-bit applications in IIS Activated

Answer

James McCormack picture James McCormack · Oct 14, 2014

Check the site's Application Pool in IIS / Application Pools / YourPool / Advanced Settings :

  • Advanced / Enable 32-Bit Applications: True

There's some anecdotal evidence to suggest you do this too:

  • Managed Pipeline Mode : Classic

Related questions

Detailed 500 error message, ASP + IIS 7.5

IIS 7.5 , 2008rc2, classic asp, 500 error msg: The page cannot be displayed because an internal server error has occurred. I need to know how to configure IIS to get a more detailed error. I've tried setting to true all of debugging …

Read More
Update div with jQuery ajax response html

I am trying to update a div with the content from an ajax html response. I beleive I have the syntax correct, however the div content gets replaced with the entire HTML page response, instead of just the div selected …

Read More
File URL "Not allowed to load local resource" in the Internet Browser

I've got a major brainteaser. I want to open a file in classic ASP. I'm using various variables because things can change but the outcome is correct. I know this because I've tested the outcome by copying the linkadress and …

Read More