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

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 - stackoverflow.com/questions/10374808/… — Shakti Prakash Singh
– Shakti Prakash Singh, Commented Feb 26, 2014 at 10:16

Community · Accepted Answer · 2017-05-23 12:31:22Z

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, 2017 at 12:31

CommunityBot

11 silver badge

answered Feb 26, 2014 at 10:20

Shakti Prakash Singh

2,5335 gold badges36 silver badges61 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Bitterblue Over a year ago

Q+1, A+1, Thank god, there are answers that give me exactly what I need.

Collectives™ on Stack Overflow

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

1 Answer 1

1 Comment

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Linked

Related