Connection of Visual Studio to an Access database

Question

I have a string connection to the Access database:

@"Provider=Microsoft.ACE.OLEDB.12.0;Data Source=|DataDirectory|\lentes.accdb;Persist Security Info=False";

When I run this code always gives error " There is no support for the keyword 'Provider''."

P.S. has nothing after that code yet, that’s all:

 string strcon = @"Provider=Microsoft.ACE.OLEDB.12.0;Data Source=|DataDirectory|\lentes.accdb;Persist Security Info=False";
            SqlConnection con = new SqlConnection(strcon);
            con.Open();

Then I run Try and catch to see the error and this error I said.

Answer 1

You are trying to create an ACCESS connection using Assembly System.Data.Sqlclient.

For Acces, you must use Assembly System.Data.Oledbclient

Here an example of code:

public void ConnectToAccess()
{


  System.Data.OleDb.OleDbConnection conn = new 
      System.Data.OleDb.OleDbConnection();
    conn.ConnectionString = @"Provider=Microsoft.Jet.OLEDB.4.0;" +
        @"Data source= C:\Documents and Settings\username\" +
        @"My Documents\AccessFile.mdb";
    try
    {
        conn.Open();
    }
        catch (Exception ex)
    {
        MessageBox.Show("Failed to connect to data source");
    }
    finally
    {
        conn.Close();
    }
}