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.