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

Graeme
Graeme used Ask the Experts™
on
Hi there, I have just migrated across to a 2016 Server and having some issues running a site, have no idea why this is happening, as I can see the settings are the same in IIS

ADODB.Connection error '800a0e7a'

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

oConn.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source="&Server.MapPath("core/allcore.mdb")

Open in new window


Any help would be amazing!
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Ryan ChongSoftware Team Lead

Commented:
ADODB.Connection error '800a0e7a'

Provider cannot be found. It may not be properly installed.
You may need to install it.

Microsoft Access Database Engine 2010 Redistributable
https://www.microsoft.com/en-us/download/details.aspx?id=13255
Graemewebber4technologies

Author

Commented:
Hi Ryan, just installed the software, same error :(
webber4technologies
Commented:
Found what it was...

The Pool Application that I was using was not enabled for 32-bit

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial