>Hi,
>We have a third-party app written in .NET for which we need to supply the ODBC connection string to a VFP table. We have tried many connection strings and we have not been successful. Our table can be free or in a .DBC, whichever is best to get this thing working. Any examples? Suggestions?
>TIA,
>Mark
Why would they ever need ODBC connection string. There is VFPOLEDB that works much better and works with VFP9 too. ie:
string strCon = @"Provider=VFPOLEDB;
Data source=C:\Program Files\Microsoft Visual Studio\MSDN\2001OCT\1033\SAMPLES\VFP98\data\Testdata.dbc";
For free tables either you mgiht use an existing dbc as above or simply the path:
string strCon = @"Provider=VFPOLEDB;Data source=C:\My Path\";
Cetin