How to resolve Microsoft jet oledb 4.0 provider is not registered error

When you are installing new software or application on 64bit operating system, you may find the error “microsoft jet oledb 4.0 provider is not registered”. Microsoft jet oledb 4.0 doesn’t works for 64bit machine.

You can use Microsoft.ACE.OLEDB.12.0 for 64 operating system bit system. You can check is it 32 bit or 64 bit system. If 32 bit then use Microsoft.JET.OLEDB else use Microsoft.ACE.OLEDB.

There is not a 64 bit version of jet that is why you get that error.  To force your app to use the 32 bit change the target CPU to x86 in the advanced compiler options.

To resolve this issue open the project in Visual Studio then:

1. From the solution explorer right-click your project then click Properties

2. Click the Build tab

3. Change Platform target from: Any CPU to x86

4. Re-build your solution

Latest Service pack for Microsoft Jet 4.0 Database Engine

http://support.microsoft.com/kb/239114/en-gb

 

 

Filed Under: Windows

Tags:

About the Author:

RSSComments (0)

Trackback URL

Leave a Reply




If you want a picture to show with your comment, go get a Gravatar.