Error Opening Access Database with C# Application

Question

I'm updating a C# (.NET 3.5) application to interact with an Access database, but I keep getting this error:

ERROR: Unrecognized database format

This is the code I'm using to open a connection to the database:

        String connectionString = "Provider=Microsoft.Jet.OLEDB.4.0; " +
            "Data Source=" + filePath;

        try
        {
            this.conn = new OleDbConnection(connectionString);
            this.conn.Open();
        }
        catch (Exception e)
        {
            Console.WriteLine("ERROR: " + e.Message);
            Console.WriteLine(e.ToString());
        }

I know that the file path is correct. I suspect that the Provider=Microsoft.Jet.OLEDB.4.0; is incorrect. How do I find out what the database format is? I did not make the database in question, but I do have read-access to it. Thanks.

connectionstrings.com/access-2007

JonH
– JonH

2011-11-01 20:00:16 +00:00
Commented Nov 1, 2011 at 20:00 — JonH
– JonH, Commented Nov 1, 2011 at 20:00

Sergey Gazaryan · Accepted Answer · 2011-11-01 20:00:57Z

1

You must add Data Source , user/password parametters . You can see http://connectionstrings.com/access

answered Nov 1, 2011 at 20:00

Sergey Gazaryan

1,0431 gold badge9 silver badges25 bronze badges

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

Collectives™ on Stack Overflow

Error Opening Access Database with C# Application

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related