Connection to a Visual FoxPro DBF file using Web.Config

I have put my web-site together and everything works fine when working on my computer. I have one page that works with a Visual FoxPro table (dbf). In my web.config file, the only way to get it to find the table is to put in the complete path to the file. The file on my site is located in the App_Data folder off of the root of my web-site. Here is the connection string that works on my local computer when running under Visual Web Developer:

<connectionStrings>
<add name="ADAInfoConnectionString"
connectionString="Provider=VFPOLEDB.1;Data Source='C:\Users\David\Documents\Visual Studio 2005\WebSites\Damar\App_Data\adasurvey.dbf'"
providerName="System.Data.OleDb" />
</connectionStrings>

How can I get my ASP.Net application to find this table on my web-site?

Any help would be much appreciated.

Thanks!

Dave

 

Bruce,


It's not so much a VFP issue as it is the path to the table. Nothing seems to work in my web.config file.


Dave