>Hi all,
>
>Someone knows how to define the "ConnectionString" using OLEDB to access FoxPro tables?
You can see what connection string should be by performing following steps
- Create text file with extension .UDL
- Double click on it and fill all the info required
- Open file in any text editor
Below are sample connection strings copied from such .UDL files.
lcConStr = [Provider=VFPOLEDB.1;] + ;
[Data Source=C:\Program Files\Microsoft Visual FoxPro 7\Samples\Data\testdata.dbc;] + ;
[Share Deny None;Password="";Collating Sequence=MACHINE]
lcConStr = [Provider=VFPOLEDB.1;] +
[Data Source=h:\temp;]
[Share Deny None;Password="";Collating Sequence=MACHINE]
--sb--