>>>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=dbffoxpro>
>Here is the full path on my development box: C:\Inetpub\wwwroot\RTP\App_Data\2040SharedFiles\2040RTP.dbc
Try double slash
C:\\Inetpub\\wwwroot\\RTP\App_Data\\2040SharedFiles\\2040RTP.dbc
Does the ASPNET user have access to the folder with the DBC?
Semper ubi sub ubi.