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

Question

I am having a problem with my application. When it is run, the error displays

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

I tried changing Platform to X86 CPU but it could not be changed, the only available option is Any CPU.

Please advise how to get rid of this error.

Thanks

Answer 1

you are using the Jet.OLEDB.4.0 driver, which gives that error when run on 64 bit system, it is better to install the new driver Microsoft Access Database Engine 2010 Redistributable

http://www.microsoft.com/download/en/details.aspx?id=13255

also you'll need to change the connexion string from “Provider=Microsoft.Jet.OLEDB.4.0; “ to “Provider=Microsoft.ACE.OLEDB.12.0;”

reference from my blog : 64 bit version of ‘Microsoft.Jet.OLEDB.4.0’ Office 2007/2010 Jet drivers

hope this helps.