Click here to Skip to main content
11,412,451 members (66,606 online)
Click here to Skip to main content

OLEDB Provider is Not Registered on the Local Machine

, 8 Jul 2012 CPOL
Rate this:
Please Sign up or sign in to vote.
Solution for Exception: The 'Microsoft.ACE.OLEDB.12.0' 'Microsoft.Jet.oledb.4.0' provider is not registered on the local machine.

Introduction

While working with Microsoft Access Database connectivity with ADO.NET, you might have received this error:

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

Background

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

Problem

Solution

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:

  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.

  4. Select x86 from the new platform dropdown:

  5. Compile and run your application.

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

License

This article, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Share

About the Author

Shemeer NS
Software Developer (Senior)
India India
Technology Specialist | CodeProject MVP | Visual Studio Gallery Contributor | Author | Geek | Netizen | Husband | ChessPlayer

Most of my articles are listed on top 5 of the respective 'Best articles of the month' and some of my articles are published on ASP.NET WebSite's Article of the Day section.

Check my contributions in Visual Studio Gallery and Code Project

Technical Blog: http://www.shemeerns.com
Facebook: http://facebook.com/shemeernsblog
Twitter : http://twitter.com/shemeerns
Google+ : http://google.com/+Shemeernsblog
Follow on   Twitter   Google+

Comments and Discussions

 
QuestionWhy do we need to change platform to * 86? will my software work on every CPU? Pin
tommmmmy at 3-Apr-15 9:21
membertommmmmy3-Apr-15 9:21 
GeneralRe: Why do we need to change platform to * 86? will my software work on every CPU? Pin
PIEBALDconsult at 3-Apr-15 9:40
protectorPIEBALDconsult3-Apr-15 9:40 
Answeralternate solution Pin
skannan74 at 18-Mar-15 1:50
memberskannan7418-Mar-15 1:50 
AnswerIn my case I can't switch my application from 64-bit to 32-bit. i found my solution as described below. Pin
rahul-techie at 12-Feb-15 23:21
memberrahul-techie12-Feb-15 23:21 
QuestionThanks. It worked for me :) Pin
Jerin Kurian at 3-Dec-14 19:01
memberJerin Kurian3-Dec-14 19:01 
QuestionOLEDB Provider is Not Registered on the Local Machine Pin
ckarstedt at 7-Oct-14 13:44
memberckarstedt7-Oct-14 13:44 
QuestionGreat Work Pin
ImranSyed at 30-Sep-14 19:18
memberImranSyed30-Sep-14 19:18 
GeneralMy vote of 5 Pin
Avelino Ferreira at 28-Jul-14 10:23
memberAvelino Ferreira28-Jul-14 10:23 
GeneralRe: My vote of 5 Pin
AIturralde at 9-Sep-14 10:29
memberAIturralde9-Sep-14 10:29 
Answersolution Pin
info.mohamed at 27-Apr-14 2:03
memberinfo.mohamed27-Apr-14 2:03 
QuestionThanks you, it work for me ! Pin
thichngaodu at 28-Jan-13 1:32
memberthichngaodu28-Jan-13 1:32 
AnswerRe: Thanks you, it work for me ! Pin
Maimonides at 15-Aug-13 2:42
professionalMaimonides15-Aug-13 2:42 
Answermicrosoft.ace.oledb.12.0 provider is not registered on the local machine. Pin
Joannou H. Fegarido at 8-Oct-12 19:21
memberJoannou H. Fegarido8-Oct-12 19:21 
Try this link for more details: http://www.tesear.com/2012/10/how-to-fix-error-microsoftaceoledb120.html[^]
GeneralRe: microsoft.ace.oledb.12.0 provider is not registered on the local machine. Pin
Shemeer NS at 8-Oct-12 21:45
memberShemeer NS8-Oct-12 21:45 
QuestionThe 'Microsoft.Jet.OLEDB.4.0' provider is not registered on the local machine Pin
Giri Dasari at 28-Sep-12 2:07
memberGiri Dasari28-Sep-12 2:07 
AnswerRe: The 'Microsoft.Jet.OLEDB.4.0' provider is not registered on the local machine Pin
Shemeer NS at 28-Sep-12 2:31
memberShemeer NS28-Sep-12 2:31 
GeneralRe: The 'Microsoft.Jet.OLEDB.4.0' provider is not registered on the local machine Pin
brother.gabriel at 10-Jan-14 12:04
memberbrother.gabriel10-Jan-14 12:04 
GeneralThoughts Pin
PIEBALDconsult at 9-Jul-12 4:57
memberPIEBALDconsult9-Jul-12 4:57 
GeneralRe: Thoughts Pin
Shemeer NS at 9-Jul-12 5:01
memberShemeer NS9-Jul-12 5:01 
GeneralMy vote of 3 Pin
Guillaume Leparmentier at 8-Jul-12 9:01
memberGuillaume Leparmentier8-Jul-12 9:01 
GeneralRe: My vote of 3 Pin
Shemeer NS at 8-Jul-12 11:15
memberShemeer NS8-Jul-12 11:15 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.

| Advertise | Privacy | Terms of Use | Mobile
Web04 | 2.8.150427.1 | Last Updated 8 Jul 2012
Article Copyright 2012 by Shemeer NS
Everything else Copyright © CodeProject, 1999-2015
Layout: fixed | fluid