Visual studio 2010 having problem to connect to access database

Question

0.00/5 (No votes)

See more:

Hello guys developers, I had a problem with my visual studio 2010 Express, it has been working properly but now, it is said to have some issues, it used to allow me to connect to The 'Microsoft.ACE.OLEDB.12.0' provider but now is said that is not registered on the local machine.

It has now shifted to Microsoft.jet.OLEDB.4.0, I m using microsoft 2007, now as I m using it access as database, it is no accept to be connected to it. I don't know how to resolve that issue, I tried to uninstall visual basic studio 2010 express and reinstall it again but still the problem remain the same. if need someone's help to handle that.

Thank u

Posted 23-Aug-13 0:43am

DAVID DUSHIMIMANA

Add a Solution

Comments

Richard MacCutchan 23-Aug-13 7:31am

This has nothing to do with Visual studio. You must have the correct library installed on the system where you run the code. Also check that your connection string correctly matches the target library.

2 solutions

Solution 2

save your Database as *.accdb(provider=Microsoft.ACE.OLEDB.12.0) not *.mdb(provider=Microsoft.Jet.OLEDB.4.0)

Posted 26-Aug-13 14:30pm

Douaa Ouchtati

Comments

DAVID DUSHIMIMANA 27-Aug-13 1:45am

It has been changed to Microsoft.jet.OLEDB.4.0 and I changed the database to mdb but I don't know why when I m saving through vb.net interface after a while the datal stored in database disappear. what make such problem?

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)

Hasan Habib Surzo · Accepted Answer · 2013-08-26T02:03:00

Solution 1

provider=Microsoft.ACE.OLEDB.12.0
change it to
provider=Microsoft.Jet.OLEDB.4.0

Posted 26-Aug-13 2:03am

Hasan Habib Surzo