'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine.

Question

0.00/5 (No votes)

See more:

Hi,

My PC configuration 64 -bit formate and MS- Office formate is 32 - bit formate. And i install AccessDataBaseEnginee also 32 bit formate . Then also i'm facing the same problem

'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine.

can anyone help me to resolve this issue..

Posted 14-Dec-12 22:02pm

pranathis012

Updated 17-Dec-12 1:02am

v2

Add a Solution

5 solutions

Solution 5

install office 2007 in your system. Not later or previous versions

Posted 8-May-14 20:52pm

sanjeevka08

Solution 1

http://social.msdn.microsoft.com/Forums/en-US/vstsdb/thread/1d5c04c7-157f-4955-a14b-41d912d50a64[^] contains your solution..

Posted 14-Dec-12 22:05pm

Krunal Rohit

Comments

[no name] 15-Dec-12 4:54am

k in my pc i installed this S/w , and again i try to debug my page it's showing the same problem what should i do

[no name] 15-Dec-12 4:55am

try installing Office System Driver

[no name] 15-Dec-12 5:04am

Hey i already download the Software and installed in my PC also

[no name] 15-Dec-12 5:02am

Please send me the URL to download this

Solution 3

http://sharepointtweets.blogspot.in/2013/07/read-each-worksheet-from-excel-file.html[^]

Posted 19-Jul-13 0:29am

vinaykn.rao

Solution 4

Quote:
Hi,

I think this issue is caused by you are running 64-bit windows and there are no MS Access drivers that run 64-bit. So I suggest you trying to change your build configuration to x86. You can do that on the project properties dialog under "Compile>Advanced Compile Options...>Target CPU". Change it to "x86". Then clean and rebuild your solution.

Hope that helps.

Thanks & Regard
Sham :)

Posted 19-Jul-13 0:37am

Shambhoo kumar

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

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

StackQ · Accepted Answer · 2012-12-14T22:17:00

Solution 2

While working with Microsoft Access Database connectivity with 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 ...
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

OLEDB Provider is not registered on the local machine[^]

may solve ur problem.

Posted 14-Dec-12 22:17pm

StackQ

Updated 19-Jul-13 20:29pm

v2

Comments

[no name] 15-Dec-12 5:07am

I followed those steps and then install office system driver s/w from this link
http://www.microsoft.com/en-us/download/confirmation.aspx?id=23734
and install it in my PC then also i'm facing the same problem

Tarkus_ 21-Sep-13 6:59am

Changing the project configuration to x86 solved the problem,thank you very much

StackQ 15-Dec-12 5:10am

restart ur pc again.

Raghavendra M 27-Sep-13 6:50am

Thank u . . Thank u very much . . , I was also facing same problem , now it resolved . .

[no name] 15-Dec-12 5:10am

k

Member 9999566 8-Oct-13 18:19pm

Didn't resolve the issue for me. Is there anything additional I need to do?

[no name] 15-Dec-12 5:25am

Again same problem

StackQ 15-Dec-12 5:47am

try to export data through sqlConnection.

Member 9731117 28-Mar-14 13:29pm

when we run his exe on other machin then i get this error if any have solution plz send on my mail id 'anand.pandit42@gmail.com'

'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine.

sanjeevka08 9-May-14 2:51am

install office 2007 in your system. Not later or previous versions