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

.net vb.net jet
Furqan Sehgal picture Furqan Sehgal · Nov 16, 2011 · Viewed 30.7k times · Source

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

Chtiwi Malek picture Chtiwi Malek · Mar 7, 2012

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.

Related questions

What is a NullReferenceException, and how do I fix it?

I have some code and when it executes, it throws a NullReferenceException, saying: Object reference not set to an instance of an object. What does this mean, and what can I do to fix this error?

Read More
Why is Dictionary preferred over Hashtable in C#?

In most programming languages, dictionaries are preferred over hashtables. What are the reasons behind that?

Read More
How to enable assembly bind failure logging (Fusion) in .NET

How do I enable assembly bind failure logging (Fusion) in .NET?

Read More