Thursday, 22 September 2016

The 'microsoft.ace.oledb.12.0' provider is not registered on the local machine - Resolved

        In this post we are going to see the interesting issue like "The microsoft.ace.oledb.12.0" provider is not registered on the local machine , first let we understand why this issues are raising, then we go step by step process how to resolve this.

While working with the Microsoft Access Database , we may receive error like following

Why this error is raising , There are number of reasons why we get this error, when trying to connect access or xlsx file, The ACE provider is not installed on operating systems by default., so how we can resolve this error, we have to many steps , anything solution can resolve your issues. because by default this settings needed by application.

For web applications first we have to do the following steps.

Solution 1:

1. Open the run window , Type inetmgr and press Enter
2. Now IIS will be there, Next select the application pool, under which your application is running

3. Go to the Advance settings, enable 32-bit application "True"

For Visual studio projects, we have to change the build

Solution 2:

1. Open your project in visual studio
2. Right click on the solution in solution explorer

3. Click on the Configuration manager 
4. Click on the Active Platform Drop down, if x86 is already there then select that, else click on New.

5. Select x86 as new target platform

6. Compile the Project

For Windows Applications
Solution 3:
you can do this settings in project level also,  by setting the target platform as X86 by using the following steps  
Select the project =>properties => Debug => Platform Target=> X86
Select the Project => Properties => Build => Platform Target => X86

Solution 4:

Step 1:
If above step doesn't work for you ,then  try below steps
Try to connect the access database from visual studio , if you get error then install the following thing

Step 2:
If above step doesn't work for you ,then  try below steps,

 Note: It will work for Office 2010, even though it is 2007 

Step 3:
Again if you have issues , try below steps
Install the following Office system drivers from following link

Step 4:

Install MS Office in the system

From the above steps you can  learn how to resolve the isssue "Microsoft.ACE.OLEDB.12.0 provider is not registered on the local machine"

1 comment:

  1. This comment has been removed by a blog administrator.