The Following connection string setting works.
<connectionStrings>
<add name="VFPLibrary" connectionString="Provider=VFPOLEDB.1;Data Source = '"c:\inetpub\wwwroot\aspxtest\app_data\library.dbc"'" providerName="System.Data.OleDb"/>
</connectionStrings>
but this one does not.
<connectionStrings>
<add name="VFPLibrary" connectionString="Provider=VFPOLEDB.1;Data Source='"|DataDirectory|library.dbc"'" providerName="System.Data.OleDb"/>
</connectionStrings>
The latter is supposed to provide for relative pathing to the data but produces an error that says the file or path is invalid. Can someone show me the correct syntax for a relative path in the connection string?
Thanks
