>>>>>>>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?
>>>
>>>I'm afraid you miss the point. The absolute path will work fine on my development box, but it will not be correct when I move it to the server. What I want is a relative path.
>>
>>I use the |DataDirectory| syntax when I publish the app. I have a different web.config to use for development or just keep commenting the keys back and forth.
>>Tim
>
>The DataDirectory syntax works fine on my dev box IF the DBC is directly under it. However in this case I'm another folder down and I can't quite seem to get it right.
OIC, I haven't tried it but once the connection string is created can you just add your additional directory to the path after the "App_Data\ "? There is probably a better way, but not sure what it is.
Timothy Bryan