Connect Access Database from c#

0
votes

I’m trying to open Access database. 

OleDbConnection conn = null;
OleDbDataReader reader = null;


conn = new OleDbConnection(
    "Provider=Microsoft.ACE.OLEDB.12.0; " +
    "Data Source=" + @"C:\test.accdb");
conn.Open();

But on conn.Open, I’m getting exception - Unrecognized database format "C:\test.accdb"

Im’ created this db with Access 2010. So, I’m tried to Access this db using this: http://www.microsoft.com/en-us/download/details.aspx?id=13255 But then I’m get exception „Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine.” Now I’m trying this: http://www.microsoft.com/en-us/download/details.aspx?id=23734 And getting this Unrecognized database format exception.

1
c#ms-accessoledb

1 Answers

0
votes

Try this

OleDbConnection Con = new OleDbConnection(@"Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\test.accdb");