16 December 2008

C# MS Access Connection String OLE DB OleDbConnection

The Connection String for MS Access can be set as ; 
 private constr =
"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=yourdbfile.mdb;
Jet OLEDB:Database Password=yourpassword;";
And the C# code to connect to MS Access database ; 
 public bool OpenConnection()
{
OleDbConnection con; con = new OleDbConnection(constr);

if (con.State != ConnectionState.Open)
{
 try
 {
   con.Open(); return true;
 }
catch (Exception) { return false; }
}
else return false;
}
C# Access Connection String OLE DB OleDbConnection password field is the password you set up in access database.
at

3 comments:

  1. Anonymous1/11/2012 5:53 AM

    private String constr =
    "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=yourdbfile.mdb;
    Jet OLEDB:Database Password=yourpassword;";

    ReplyDelete
  2. Yelinna1/11/2013 9:17 AM

    This was really really helpful, thankzzz!!

    ReplyDelete
  3. Anonymous5/04/2013 3:15 AM

    try this simple code

    string connetionString = null;
    OleDbConnection cnn ;
    connetionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=yourdatabasename.mdb;";
    cnn = new OleDbConnection(connetionString);
    try
    {
    cnn.Open();
    MessageBox.Show ("Connection Open ! ");
    cnn.Close();
    }
    catch (Exception ex)
    {
    MessageBox.Show("Can not open connection ! ");
    }

    curos

    ReplyDelete

Note: Only a member of this blog may post a comment.