>>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.
>>
>>Thanks
>
>What is |DataDirectory| ?
>
http://www.connectionstrings.com/?carrier=dbffoxproHere is the full path on my development box: C:\Inetpub\wwwroot\RTP\App_Data\2040SharedFiles\2040RTP.dbc