>How do you format a connection string path when the data is in a folder under the app_data folder?
>
>I have
>

><add name="vfpRTP2" connectionString="Provider=VFPOLEDB.1;Data Source=|DataDirectory|2040sharedfiles\2040rtp.dbc" providerName="System.Data.OleDb"/>
>

>Which works when I run the form but fails when I configure the datasource.
>
>The problem seems to be with the folder delimiters. I have tried several combinations but can't find the right one.

If this is ASP.NET then try checking in code that '|DataDirectory|' is what you think it is:

string WhereItsLooking = (string)AppDomain.CurrentDomain.GetData("DataDirectory");

Also,by default, the value is stored without a trailing backslash - so you need to add that....