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:-
- Installed this 64-bit driver Microsoft Access Database Engine 2010 Redistributable
- On application pool --> properties, Set
Enable 32 bit
toTrue
and WithClassic
pool. - 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'
" - Build your project by setting
target platform
toAny 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
Changing the User Agent of the Webbrowser Control
Why Can't I Have Abstract Static Methods in C#
System.Text.JSON.JSONelement Toobject Workaround
How to Enable Http Put and Delete for ASP.NET MVC in Iis
Differencebetween Await Task<T> and Task<T>.Result
How to Count Duplicates in List with Linq
Headless Browser for C# (.Net)
Shouldserialize*() VS *Specified Conditional Serialization Pattern
Tolist()-- Does It Create a New List
Multiple Httppost Method in Web API Controller
Using Global Keyboard Hook (Wh_Keyboard_Ll) in Wpf/C#
Do You Have to Put Task.Run in a Method to Make It Async
Best Way in ASP.NET to Force Https for an Entire Site
How Do the Major C# Di/Ioc Frameworks Compare