Admin-Ahead Community

Windows => General Windows => Topic started by: sajugovind on September 21, 2014, 09:12:42 pm

Title: The 'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine
Post by: sajugovind on September 21, 2014, 09:12:42 pm
While working with Microsoft Access Database connectivity with ADO.NET, you might have received this error:

Code: [Select]
The 'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine
The 'Microsoft.Jet.oledb.4.0' provider is not registered on the local machine

I got this error when I was connecting ADO.NET with Access 2010 database from Visual Studio 2010 C#.

You need to change the Solution Platform from "Any CPU" to "x86". The steps are given below:

1. Right click on the Solution File in Solution Explorer:

(https://admin-ahead.com/forum/gallery/529_21_09_14_9_04_01.png)

2. Click on the Configuration Manager.

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

(https://admin-ahead.com/forum/gallery/529_21_09_14_9_04_37.png)

4. Select x86 from the new platform dropdown:

(https://admin-ahead.com/forum/gallery/529_21_09_14_9_04_54.png)

5. Compile and run your application.

If you are still facing the issue, then try installing Office System Driver from below link.

http://www.microsoft.com/en-us/download/confirmation.aspx?id=23734 (http://www.microsoft.com/en-us/download/confirmation.aspx?id=23734)

Thank you,