Getting Error 800a0e7a “Provider cannot be found.

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 / YourPoolHere / Advanced Settings :

1) Managed Pipeline Mode : Classic
2) Advanced / Enable 32-Bit Applications: True

Answer 2

Have you got the driver installed? If you go into Start > Settings > Control Panel > Administrative Tools and click the Data Sources, then select the Drivers tab your driver info should be registered there.

Failing that it may be easier to simply set up a DSN connection to test with.

You can define multiple connection strings of course and set-up a 'mode' for working on different machines.

Also there's ConnectionStrings.com.

-- EDIT --

Just to further this, I found this thread on another site.