connecting to Access DB from C#

Question

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

kovan · Answer

public void openAccess2KDB() { OleDbConnection conn = null; string strDSN = Provider=Microsoft.Jet.OLEDB.4.0;Data Source= + GlobalStuff.AccessDBPath; conn = new OleDbConnection(strDSN); conn.Open(); }

xkabuff · Answer

try it like this: Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\Database.mdb;Persist Security Info=False

miker · Answer

http://www.connectionstrings.com/

chris.bezant · Answer

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.