Using FoxPro tables using Advantage OLE DB

Connection string

This Advantage OLE DB Provider connection string can be used for connections to Sybase Advantage.

Provider=Advantage OLE DB Provider;User ID=adssys;
Data Source=MyDataDictionaryPath;TableType=ADS_CDX;
Advantage Server Type=ADS_LOCAL_SERVER;

If not specifying the TableType value the default value of "ADS_ADT" will be used.