Access database in C# console application

Question

The current problem I'm having is an error message that it could not find file C: now I dont know what the problem is because the file is in that location. I have I tried in both .accbd and .mbd.

private static OleDbConnection GetConnection()    
{
    OleDbConnection conn = new OleDbConnection();
    String connectionString = 
            @"Provider=Microsoft.JET.OlEDB.4.0;"
            + @"Data Source= C:\Temp\F1\Docs\Expeditors Project\Table1.accbd";

    conn = new OleDbConnection(connectionString);
    conn.Open();
    return conn;
}

read the contents of file separately and use the string in connectionString — AnjumSKhan
– AnjumSKhan, Commented Jan 5, 2016 at 6:45

Nik Bo · Accepted Answer · 2016-01-05 06:50:11Z

2

Do you tried another Provider? For example:

Provider=Microsoft.ACE.OLEDB.12.0;
Data Source=C:\Temp\F1\Docs\Expeditors Project\Table1.accbd;

answered Jan 5, 2016 at 6:50

Nik Bo

1,3402 gold badges17 silver badges29 bronze badges

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

1 Comment

Nik Bo Over a year ago

Nice to hear that this helps

Yogi · Accepted Answer · 2016-01-05 07:35:06Z

2

try \\ in Data Source Path

like below -

OleDbConnection con = new OleDbConnection(@"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=D:\\Data\test.mdb;Persist Security Info=False");

edited Jan 5, 2016 at 7:35

Yogi

9,8693 gold badges49 silver badges64 bronze badges

answered Jan 5, 2016 at 6:59

Varsha Vekariya

669 bronze badges

Comments

Dead End · Accepted Answer · 2016-01-05 06:56:15Z

1

try this `

    `private static OleDbConnection GetConnection() throws SQLException{
        { 
    if (conn==null) 
{ 
            try{                                                                                    OleDbConnection conn = new OleDbConnection();
            String connectionString = @"Provider=Microsoft.JET.OlEDB.4.0;"
                                      + @"Data Source= C:\Temp\F1\Docs\Expeditors Project\Table1.accbd";
            conn = new OleDbConnection(connectionString);
            conn.Open();

            return conn;
        }}
    catch(Exception e){
    e.printStackTrace();
    }

answered Jan 5, 2016 at 6:56

Dead End

5872 gold badges4 silver badges17 bronze badges

Collectives™ on Stack Overflow

Access database in C# console application

3 Answers 3

1 Comment

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

1 Comment

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related