title: How to connect Ms access 2010 (.accdb ) database with odbc driver
body: <p>Can any one tell how to connect Ms access 2010 (.accdb ) database with odbc driver in c# and .NET 4.0</p>
  
  <p>I tried </p>
  
  <pre><code>string connetionString = ("Driver={Microsoft Access Driver(*.mdb*.accdb)};DBQ=C:\\Users\\Administrator\\Desktop\\New folder\\MatchDetails.accdb;");
  
  OdbcConnection myConnection = new OdbcConnection(connetionString);
  
  try
  {                   
      myConnection.Open();
      MessageBox.Show("Connection Open ! ");
      myConnection.Close();
  }
  catch (Exception ex)
  {
      MessageBox.Show("Can not open connection ! ");
  }
  </code></pre>
  
  <p>throwing this Exception</p>
  
  <blockquote>
    <p>ERROR [IM002] [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified exception</p>
  </blockquote>