64 bit version of ‘Microsoft.Jet.OLEDB.4.0’ Office 2007/2010 Jet drivers

When an application or a website page hosted on a 64 bit system tries to connect to a Jet driver, you can get this error:

The 'Microsoft.Jet.OLEDB.4.0' provider is not registered on the local machine.

You are getting this error because the Jet driver you have installed need 32 bit OS & system to function, Here’s how to update to a new 64-bit compatible database engine:

1/ Download the Microsoft Access Database Engine 2010 Redistributable, you can choose from the 32 bit or 64 bit version depending on your machine and install it on your server

Click Here To Download

2/ in your application or website code, update the connection string from “Provider=Microsoft.Jet.OLEDB.4.0; “ to “Provider=Microsoft.ACE.OLEDB.12.0;”

3/ recompile and run your application

That’s all, but if you don’t want to use the new OLEDB you still can force the Jet OLEDB 4.0 to run on a 64 bit environment : http://www.codicode.com/art/the_microsoft_jet_oledb_4_0_prov.aspx