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



Comments

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...

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

Static Keyword in C#, unleashing Static keyword in C#

What is Static keyword in C# “Static” keyword can be used for declaring a static member . The keyword Static can be applied to the Classes, field, method, properties, operator, event and constructors. Methods and variable  which we use as static doesn't need an instance to be created of a class. Example of static keyword class testclass {     public static int statint;     public static void squareroot(); } we can call the above static method and variable without creating the instance of the class How to call a static method  testclass.squareroot(); apart from this the static method can use only the static variables of same class.