Skip to main content

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

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


This is the error which most of the people face, I also faced this error and searched in google and found a lot of websites which are giving solution to the problem(The 'Microsoft.Jet.OLEDB.4.0' provider is not registered on the local machine') , but this is of no use.

But there are some websites which can really help you in this matter, This error you can also get while compiling an application in machines like x64 or x86.
There are two solutions to it

1) If you are in development (Microsoft.Jet.OLEDB.4.0' provider is not registered on the local machine)

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

1. From the solution explorer right-click on project name then click on Properties
2. Click on the Build tab
3. Change Platform target from: Any CPU to x86
4. Re-build your solution
5. You are good to go


2) If your application is hosted on IIS(Microsoft.Jet.OLEDB.4.0' provider is not registered on the local machine)

This will happen if you have an Ms Office application/DLL incorporated in you application, Very simple steps

1) Open IIS manager
2) Select Application Pools
3) Select the application pool you are using in your website
4) Click on Advanced Settings in the right-pane of the window.  
5) Under General section, set "Enable 32-Bit Applications" to "True".
6) Done Enjoy,

You may also want to look at some of my other postings like



Labels

Labels:

Comments

Post a Comment

Popular posts from this blog

Http 500.50 URL Rewrite Error

Symptoms: HTTP Error 500.50 - URL Rewrite Module Error. Error Information Module- RewriteModule Images are broken and not displayed in wordpress, Images are displayed when you edit them,Wordpress Images Broken, Wordpress Images Upload Issue This post if for the people who are searching all the pages over internet for " HTTP Error 500.50 - URL Rewrite Module Error". You might be searching for the pages which will give you solution to install/uninstall the url rewrite module.When you are running Wordpress on Windows server 2008 these types of error pops up.  So I scratched my head and started searching and found out one website which is useful in this type of error. Then I filtered everything and prepared a process for this.This will reduce your turn around time. Step-1: Open PHP.ini and search for  "upload_tmp_dir" and change the value to windows temp directory "C:\Windows\Temp" Step-2: Right click On the Windows/Temp folder and assi...
2 comments
Read more

DotNetNuke

What is DotNetNuke ? DNN (DotNetNuke) is the leading web Content Management System (CMS) for Microsoft, powering over 700,000 production web sites worldwide. DotNetNuke was written in VB.Net. It is distributed under both a Community Edition MIT license and commercial proprietary licenses i.e., Professional and Enterprise Editions. You can download the DotNetNuke Trial Edition from the below link http://www.dotnetnuke.com/Products/Professional-Edition-Trial.aspx Below link provides a quick overview of how to get up and running with DotNetNuke. http://www.dotnetnuke.com/Resources/Video-Library/Viewer/Video/449/View/Details/DotNetNuke-6-2-Getting-Started.aspx
Post a Comment
Read more

Usage of Ternary Operator

You can optimize the code by using the ternary operator, pass a parameter to this function it will compare the salary with the given value and if the condition satisfied It will print the value before the colon and if not satisfied it will print the value after colon. Ternary Operator (?:) condition ? condition satisfied : Condition not satisfied string TernaryOperatorUsage(int Salary) {     return salary >= 5000 ? "Congratulations! You are eligible for a pay hike." :                        "Sorry! You're not eligible for a pay hike."; } The above example illustrates the use of ternary operator in your code.  
Post a Comment
Read more