connection string for ms access 2007

Question

0.00/5 (No votes)

See more:

hi again, matt here

got a problem connecting to a ms access database, the string i have been given cannot be found although it is on my flash drive

this is the code:

C#

OdbcConnection dbcon = new OdbcConnection(@"Data Source=E:\\data cent\\Northwind.accdb");

now i have a button to connect

C#

private void connectButton_Click(object sender, EventArgs e)
        {
            dbcon.Open();
            connectButton.Text = "Connected";
            connectButton.BackColor = Color.Green;
        }

i get this error:

ERROR [IM002] [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified

I have added the data source manually with the data manager from the datagridview box.

Any idea where im going wrong please?

Posted 4-Feb-12 1:36am

BBCokeley

Updated 4-Feb-12 1:42am

Wendelius

v2

Add a Solution

3 solutions

Solution 1

Here[^] is the info on the connectionstrings website. I suspect you need to do more than just tell it the file location, this shows how to do that.

Posted 4-Feb-12 1:41am

Christian Graus

Comments

BBCokeley 4-Feb-12 7:46am

thanks checking it out now

Solution 2

If you're using ODBC you should first define a DSN via Control Panel and give it a name. This name is then used as a data source.

Posted 4-Feb-12 1:43am

Wendelius

Comments

BBCokeley 4-Feb-12 7:46am

thank you looking into it

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)

Aniket Yadav · Accepted Answer · 2012-02-04T01:48:00

Solution 3

Hi There,

Hope This site http://www.connectionstrings.com/access[^] will help You.

Posted 4-Feb-12 1:48am

Aniket Yadav

Comments

BBCokeley 4-Feb-12 8:53am

thank you, i have the connection string set up:
but it throws this exception all the time

@"Provider=Microsoft.ACE.OLEDB.12.0;Data Source=|DataDirectory|\Northwind.accdb"

System.Data.Odbc.OdbcException was unhandled
Message=ERROR [IM002] [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified

the site above doesnt seem to have a tutorial on driver manager, is there a site i can look up, this is getting frustrating.

just trying to display the data in a datagridview, but its having non of it.

BBCokeley 4-Feb-12 15:03pm

sorry guys, missed out + between "" so it was throwing it, bloody code...lol

thanks every one got connected :)

thank you so much