How to create ODBC Connection to Access database with code in C# 2010 Express?

Question

I am trying to connect to an Access DB using odbcConnection through ConnectionString in Properties menu in VS C# 2010 Express version. I get an error that tells me this option isn't enable in Express edition and I am forced to use other versions or code.

How I can use code for do this connection?

Have u gone through this - http://stackoverflow.com/questions/10374808/how-to-connect-to-a-ms-access-file-mdb-using-c — Shakti Prakash Singh, Feb 26 '14 at 10:16

score 5 · Answer 1 · edited May 23 '17 at 12:31

5

using System.Data.Odbc;

using(OdbcConnection myConnection = new OdbcConnection())
{
    var myConnectionString = @"Driver={Microsoft Access Driver (*.mdb)};" + 
        "Dbq=C:\mydatabase.mdb;Uid=Admin;Pwd=;";
    myConnection.ConnectionString = myConnectionString;
    myConnection.Open();

    //execute queries, etc
}

See ConnectionStrings

Reproduced from here.

edited May 23 '17 at 12:31

Community

1
1

answered Feb 26 '14 at 10:20

Shakti Prakash Singh

2,414
5
35
59

1

Q+1, A+1, Thank god, there are answers that give me exactly what I need. – Bitterblue May 15 '14 at 07:05

How to create ODBC Connection to Access database with code in C# 2010 Express?

1 Answers1