having problem when using microsoft database

Question

0.00/5 (No votes)

See more:

Hello All,

I am getting the following error while using MS-Access database.

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

when i am using it on my local machine it runs successfully but when i am putting it online....it shows the above error.

my connection string is:-

<add name="ConStr" connectionString="Provider=Microsoft.ACE.OLEDB.12.0;Data Source='F:\Web\new prjct\Db\green.mdb';" providerName="System.Data.OleDb"/>

i cant understand that is it the problem with connection string. Kindly give your valyable suggestions to solve it.

Thanks

Posted 20-Jan-13 3:08am

abhishekagrwl25

Add a Solution

Comments

Zoltán Zörgő 20-Jan-13 9:28am

Do you run your code on x64?

abhishekagrwl25 20-Jan-13 9:45am

no , m using x32 on my local machine.

2 solutions

Solution 2

Hi,

You might have to install the MDAC 2010 on that machine. You can download that from the below URL
http://www.microsoft.com/en-us/download/details.aspx?id=13255[^]

Please let me know if that works!

Posted 20-Jan-13 4:59am

Muthuraja Irullandi

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)

Richard MacCutchan · Accepted Answer · 2013-01-20T03:45:00

Solution 1

See here[^], an answer quickly found via Google.

Posted 20-Jan-13 3:45am

Richard MacCutchan

Comments

abhishekagrwl25 20-Jan-13 9:49am

actually m able to debug it on my local machine...but while i am putting it on server online...at that time it shows thid error...

for reference:- you can also see it at gfindia.org.in

Richard MacCutchan 20-Jan-13 10:04am

What part of the message "The 'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine." are you not able to understand? You need to install the provider on the machine where you are trying to access it.

abhishekagrwl25 21-Jan-13 0:57am

oh i understood and now i hv resolved the problem by converting my ms-access database from 2007 to 2003 format and using Microsoft.JET.OLEDB.4.0 as provider.

thanks for your valuable suggetions...:)

abhishekagrwl25 21-Jan-13 0:58am

x64 driver was not installed on the server.

Zoltán Zörgő 20-Jan-13 11:42am

And is the server also x86? Are you sure?