Connection failed with MS Access on Hosting server

Question

Hi,

   I am using MS Access as database for web site. To create connection string I used following code.

        string dppath="";
        OleDbConnection MSAConn;

        dbPath = HttpContext.Current.Server.MapPath("~");
        dbPath = dbPath + "\\App_Data\\dbname.accdb";

        MSAConn = new OleDbConnection("Provider=Microsoft.ACE.OLEDB.12.0; Data Source=" + dbPath + ";");

   Also I have tried ...
       MSAConn = new OleDbConnection("Provider=Microsoft.ACE.OLEDB.12.0; Data Source=" +
   HttpContext.Current.Server.MapPath("\App_Data\dbname.accdb") + ";");

These both connection string doesn't work . I am hosting this application on Shared Hosting Server.

Any help appreciated.

Regards,

Vikram

Sam Hobbs · Answer

What does " doesn't work " mean? What error do you get? If you do not get an error message then use try/catch blocks to get it. You must use the documentation provided by your shared hosting service. They should tell you what you need for the connection string.

Vikram · Answer

Thanks Hemanth for Reply. There is no any password I have set for MS Access Database. Whenever I give local path of machine then it is working fine. Now I want to upload this web site on shared hosting server whose path I don't know. So I tried with Server.MapPath() function in above format which didn't work for me. Hope I have clarify my issue. Regards, Vikram Patil

Hemant Kumar · Answer

Hi you need to frame the Connection like this 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.

Connection failed with MS Access on Hosting server

Answers (3)