PDA

View Full Version : Connecting to Access Database

shaolin
07-17-2004, 05:04 AM
Can anyone tell me how to connect to the Access database using C# code. Currently, I am doing something like this...

System.Data.OleDb.OleDbConnection conn = new System.Data.OleDb.OleDbConnection();
conn.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;" +
"Data Source=/../_database/db1.mdb;" +
"User ID=userid;" + "Password=password";

What am I doing wrong?
bruce
07-19-2004, 04:34 AM
did you get an error?


[b]quote:Originally posted by shaolin

Can anyone tell me how to connect to the Access database using C# code. Currently, I am doing something like this...

System.Data.OleDb.OleDbConnection conn = new System.Data.OleDb.OleDbConnection();
conn.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;" +
"Data Source=/../_database/db1.mdb;" +
"User ID=userid;" + "Password=password";

What am I doing wrong?
</blockquote id="quote"></font id="quote">