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

Question

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 1

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

Answer 2

You should use the provider available in your machine.

1. Goto Control Panel
2. Goto Administrator Tools
3. Goto Data Sources (ODBC)
4. Click the "Drivers" tab.
5. Do you see something called "SQL Server Native Client"?

See the attached screen shot. Here my provider will be SQLNCLI11.0