Advantage OLE DB Provider Connection Strings

Sybase Advantage

Remote Server

Provider=Advantage OLE DB Provider;User ID=adssys;Data Source=MyDataDictionaryPath;Advantage Server Type=ADS_REMOTE_SERVER;

The value "Advantage.OLEDB.1" is also applicable for the provider key, the result will be the same.

Local Server

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

Using FoxPro tables

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.

Show deleted records

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

Please note that the ShowDeleted option is only available with FoxPro tables, ie TableType="ADS_CDX".

Using OEM characters in tables

Provider=Advantage OLE DB Provider;User ID=adssys;Data Source=MyDataDictionaryPath;Advantage Server Type=ADS_REMOTE_SERVER;CharType=ADS_OEM;

If not specifying the CharType value the default value of "ADS_ANSI" will be used.

Ignoring rights

Provider=Advantage OLE DB Provider;User ID=adssys;Data Source=MyDataDictionaryPath;Advantage Server Type=ADS_REMOTE_SERVER;SecurityMode=ADS_IGNORERIGHTS;

If not specifying the SecurityMode value the default value of "ADS_CHECKRIGHTS" will be used.