connecting to Access DB from C#

chris.bezant

I am attempting my first ADO.NET program in C# and I am failing at the first hurdle. The database file is called reminders.mdb and resides in my root directory. My connection string is based on the help file data and is: "server=(local);Trusted_Connection=yes;Data Source=C:\\reminders.mdb;Provider=Microsoft.Jet.OLEDB.4.0;" The error I get is: System.Data.OleDb.OleDbException: Could not find installable ISAM I am obviously doing something fundamentally wrong. Is any kind person able to assist a newbie? Thanks

4 Replies

Know the answer? Post it — somebody with the same question will find it here.

kovan22y ago
public void openAccess2KDB() { OleDbConnection conn = null; string strDSN = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + GlobalStuff.AccessDBPath; conn = new OleDbConnection(strDSN); conn.Open(); }
xkabuff22y ago
try it like this: "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\Database.mdb;Persist Security Info=False"
miker22y ago
http://www.connectionstrings.com/
chris.bezant22y ago
I tried it with the server string removed and got the same message. The help file talks about downloading an ODBC framework update which I have just done but that made no difference.