Friday, September 10, 2010

Microsoft.Jet.OLEDB.4.0 on a 64bit OS with IIS7

When attempting to run Microsoft Jet Connection to MS Access Databases on a 64bit Machine you will get the following unhelpful error:
The 'Microsoft.Jet.OLEDB.4.0' provider is not registered on the local machine.

Googling will point you on a couple crazy paths involving recompiling your application in 32 bit mode. The solution isn't that complicated if you are using IIS7.

In IIS7 right-click on your application pool and choose "Advanced Settings"
In the dialog that opens, set "Enable 32-bit Applications" to "True".

There I fixed it.

0 comments: