I don’t know where to put this Query.
I am trying to open .dbf file from the server for which I have written below code.
Now, the problem is connection string accepts only physical path from the client machine where as I want it to pick file from the server.
Please guide me how to resolve this problem.
System.Data.Odbc.OdbcConnection oConn = new System.Data.Odbc.OdbcConnection();

oConn.ConnectionString = @"Driver={Microsoft dBase Driver (*.dbf)};SourceType=DBF;SourceDB= http://localhost:1308/CNCScheduling/...;Exclusive=No; Collate=Machine;NULL=NO;DELETED=NO;BACKGROUNDFETCH=NO;";

oConn.Open();
System.Data.Odbc.OdbcCommand oCmd = oConn.CreateCommand();

string sPathApp = Request.ApplicationPath.ToString() + "/";
string sPathFull = Request.Url.OriginalString.ToString();
int iPathFullLen = sPathFull.ToUpper().IndexOf(sPathApp.ToUpper());
string sPathPrefix = sPathFull.Substring(0, iPathFullLen) + sPathApp;
string sRPTFile = "XABCL.DBF";
string sCrvPage = "D:\\databases\\" + sRPTFile;
oCmd.CommandText = @"SELECT * FROM " + sCrvPage ;
DataTable dt = new DataTable();
dt.Load(oCmd.ExecuteReader());
help needed urgently.

Regards,
PPCC