An unhandled exception (Provider cannot be found.It may not properly installed)occured in w3wp.exe

Question

User2140234557 posted

I am getting the error when running the project locally.

I think it is not getting the Jet provide in access.

Error display in browser as follows.

ADODB.Connection error '800a0e7a'

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

/project name/databaseconnect.asp, line 14

I search on the internet and install MDAC,but not help.

I am using Windows 7 with IIS7

Please help how can i proceed.I cant be able to work on the project.

Thanks in advance.

Answer 1

User560403387 posted

You're probably running your application pool in 64bit . Jet is only available in 32 bit. Switch your application pool to 32bit in the IIS manager, and you'll be fine.

Menno

Answer 2

User2140234557 posted

how can i switch to 32 bit in inetmgr

Answer 3

User560403387 posted

Expand Server, click Application Pools, right mouse click the application pool for your app, Advanced Settings, Set Enable 32-Bit Applications to 'True'.

Menno