Click here to Skip to main content
Click here to Skip to main content

OLEDB Provider is Not Registered on the Local Machine

, 8 Jul 2012
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

 
GeneralMy vote of 5 PinmemberAvelino Ferreira28-Jul-14 9:23 
Answersolution Pinmemberinfo.mohamed27-Apr-14 1:03 
QuestionThanks you, it work for me ! Pinmemberthichngaodu28-Jan-13 0:32 
AnswerRe: Thanks you, it work for me ! PinprofessionalMaimonides15-Aug-13 1:42 
Is this a question?

It is a paradox that paradoxes would actually exist in reality.
That means of course that they don't exist.
However, they do!

(Edo)dx = Tzumer
k(this.Kid)k = this.

Answermicrosoft.ace.oledb.12.0 provider is not registered on the local machine. PinmemberJoannou H. Fegarido8-Oct-12 18:21 
GeneralRe: microsoft.ace.oledb.12.0 provider is not registered on the local machine. PinmemberShemeer NS8-Oct-12 20:45 
QuestionThe 'Microsoft.Jet.OLEDB.4.0' provider is not registered on the local machine PinmemberGiri Dasari28-Sep-12 1:07 
AnswerRe: The 'Microsoft.Jet.OLEDB.4.0' provider is not registered on the local machine PinmemberShemeer NS28-Sep-12 1:31 
GeneralRe: The 'Microsoft.Jet.OLEDB.4.0' provider is not registered on the local machine Pinmemberbrother.gabriel10-Jan-14 11:04 
GeneralThoughts PinmemberPIEBALDconsult9-Jul-12 3:57 
GeneralRe: Thoughts PinmemberShemeer NS9-Jul-12 4:01 
GeneralMy vote of 3 PinmemberGuillaume Leparmentier8-Jul-12 8:01 
GeneralRe: My vote of 3 PinmemberShemeer NS8-Jul-12 10: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 | Mobile
Web02 | 2.8.140827.1 | Last Updated 8 Jul 2012
Article Copyright 2012 by Shemeer NS
Everything else Copyright © CodeProject, 1999-2014
Terms of Service
Layout: fixed | fluid