Microsoft.Jet.Oledb.4.0' Provider Is Not Registered on the Local MAChine

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

I found a solution for this problem. The issue I described in my question occured basically due to the incompatibility of the Microsoft.Jet.OLEDB.4.0 driver in 64 bit OS.

So if we are using Microsoft.Jet.OLEDB.4.0 driver in a 64 bit server, we have to force our application to build in in 32 bit mode (This is the answer I found when I did an extensive search for this known issue) and that causes other part of my code to break.

Fortunately, now Microsoft has released a 64 bit compatible 2010 Office System Driver which can be used as replacement for the traditional Microsoft.Jet.OLEDB.4.0 driver. It works both in 32 bit as well as 64 bit servers. I have used it for Excel file manipulation and it worked fine for me in both the environments. But this driver is in BETA.

You can download this driver from Microsoft Access Database Engine 2010 Redistributable

Microsoft.Jet.oledb 4.0 is not registered on local machine Windows 7 64 bit, office 2013 for .mdb file

open IIS , Go To application pool of your website. Select Advance Settings , There will be one option : Enable 32 Bit ( second option) , It will start working

microsoft jet oledb 4.0 provider is not registered on the local machine Windows Server 2008 R2 Standard

Solved by changing IIS App Pool settings.
1. Open IIS manager and select the application pool corresponding to your application.
2. Right click on your Application Pool.
3. Select Advanced Settings.
4. Select an option Enable 32-bit Applications and change option to true.
5. Once you set this property restart your application pool.

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

Yesterday, I faced same issue.

Followed below steps which solved my problem:-

  1. Installed this 64-bit driver Microsoft Access Database Engine 2010 Redistributable
  2. On application pool --> properties, Set Enable 32 bit to True and With Classic pool.
  3. Changed Provider=Microsoft.Jet.OLEDB.4.0 to "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" + fileName + "; Extended Properties='Excel 8.0;HDR=No;IMEX=1'"
  4. Build your project by setting target platform to Any CPU.

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

That's because there is no Jet driver for 64-bit systems and I suppose you are trying to run this on a x64 bit OS. You need to compile your program to target x86. In the project properties, Build tab, set Platform target to x86.



Related Topics



Leave a reply



Submit