This article is a mirror article of machine translation, please click here to jump to the original article.

View: 19772|Reply: 0

[Source] The 'Microsoft.Jet.OleDb.4.0' provider is not registered on the local machine.

[Copy link]
Posted on 6/21/2016 3:55:21 PM | | | |
The 'Microsoft.Jet.OleDb.4.0' provider is not registered on the local machine.

Today I started migrating one of my clients website to a new 64 bits server (Windows server 2008 / IIS7), the website was previously hosted on a 32 bits server (Windows server 2003 / IIS6).

Everything went well, except that a page doing some xlsx “xcell files” parsing is returning an error:
The 'Microsoft.Jet.OLEDB.4.0' provider is not registered on the local machine.
I have already installed the Office 2007/2010 Jet drivers, but if you are having the same problem, the first thing to do is to install it:
http://www.microsoft.com/download/en/details.aspx?id=13255
If you’re still getting the same error like me, then you’ll have to allow the IIS application pool to run 32 bit applications :

Navigate to Server Manager > Roles > Web Server (IIS) > Internet Information Services (IIS) Manager, then right-click on your website’s Application Pool and click “Advanced Settings”:



Set the Enable  32-Bit Application to TRUE.


The above methods solve the problem!!! Personally tested




Previous:C# Difference between abstract classes and interfaces
Next:Handler "ExtensionlessUrlHandler-Integrated-4.0" in its module list
Disclaimer:
All software, programming materials or articles published by Code Farmer Network are only for learning and research purposes; The above content shall not be used for commercial or illegal purposes, otherwise, users shall bear all consequences. The information on this site comes from the Internet, and copyright disputes have nothing to do with this site. You must completely delete the above content from your computer within 24 hours of downloading. If you like the program, please support genuine software, purchase registration, and get better genuine services. If there is any infringement, please contact us by email.

Mail To:help@itsvse.com