Monday, December 14, 2009

How to Access an Access Database from GoDaddy

Here's a way I found useful for accessing an access database in code from GoDaddy, Hope it helps someone.

First Include:
System.Web

private static string GetConnectionString()
{
HttpContext serverContext = System.Web.HttpContext.Current;

string db_path = string.Empty;
string db_dir = serverContext.Server.MapPath("access_db") + "\\";
db_path = db_dir + "Crossroads.mdb";
string connectstr = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + db_path;
return connectstr;
}

No comments: