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.
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
(or)
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,
try to install the following http://www.microsoft.com/download/en/confirmation.aspx?id=23734
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"