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

Question

1.00/5 (1 vote)

See more:

I got error during fetching data from Excel filr my connection string & code is like that..

C#

string Filename = System.Web.Hosting.HostingEnvironment.MapPath("~//Admin//UploadFiles//" + path);
       string s = @"Data Source='" + Filename + "';Provider=Microsoft.ACE.OLEDB.12.0; Extended Properties=Excel 12.0;";
       OleDbConnection con = new OleDbConnection(s); // connection string
       con.Open();
       OleDbDataAdapter da = new OleDbDataAdapter("select * from [Sheet1$]", con);

i got this error on GoDaddy's server....

It works fine on IIS

I have already changed the Active Solution Platform from "Any CPU" to "x86".

Any suggestions are heartly welcome.. :)

Posted 15-Apr-14 23:28pm

Nirav Prabtani

Updated 15-Apr-14 23:39pm

v2

Add a Solution

3 solutions

Solution 1

First check you have the ACE driver installed, and which version: http://social.msdn.microsoft.com/Forums/en-US/f9f335c2-6c8b-4c84-a9b3-1dae73fb534d/microsoftaceoledb12-not-registered-on-local-machine?forum=adodotnetdataproviders[^] follow the instructions and it'll tell you.

If you haven't got ACE in either version, then that will also tell you what you need to do! :laugh:
Go here and install it: http://www.microsoft.com/en-gb/download/details.aspx?id=13255[^]
But remember: you can't install both 32 and 64 bit versions on the same machine!

Posted 15-Apr-14 23:35pm

OriginalGriff

Comments

Nirav Prabtani 16-Apr-14 5:38am

I got this error on GODADDY'S Sever...

OriginalGriff 16-Apr-14 6:01am

Then you need to talk to GoDaddy, not us!

Nirav Prabtani 16-Apr-14 6:08am

ya, griff i know that, i am just hopping for help that i will get some solution, thank you for your valuable time..and sorry to ask you regarding that..

OriginalGriff 16-Apr-14 6:13am

No problem!

Solution 2

A quick Google search gave about 13.000 results.
Of which the first link is:
'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine error[^]

When you read the post, the first answer leads to:
HOW TO: FIX ERROR - "the 'microsoft.ace.oledb.12.0' provider is not registered on the local machine"[^]

Never underestimate your search capabilities, these will eventually save a lot of your time in the future.

Good luck.

Posted 15-Apr-14 23:38pm

phil.o

Comments

Nirav Prabtani 16-Apr-14 5:40am

Ya correct, but my application is on godaddy's server so how is that useful??

AdamASPGeek 21-Apr-14 1:57am

Do you use shared hosting on Godaddy? If yes, it seems it cant work fine if you use Excel

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)

**Nirav Prabtani** · Accepted Answer · 2014-04-16T00:53:00

Solution 3

Got solution from this link.. :)

Excel to DataTable using EPPlus - excel locked for editing[^]

Posted 16-Apr-14 0:53am

Nirav Prabtani