Advantage ODBC Driver Connection Strings

Sybase Advantage

ALS

DataDirectory=\\servername\sharename\dictionaryfile.add;ServerTypes=1;

DataDirectory=\\servername\sharename\dictionaryfile.add;ServerTypes=2;

Internet

DataDirectory=\\servername\sharename\dictionaryfile.add;ServerTypes=4;

Try ADS, if fail; try ALS

DataDirectory=\\servername\sharename\dictionaryfile.add;ServerTypes=3;

Ignore client rights

DataDirectory=\\servername\sharename\dictionaryfile.add;ServerTypes=2;RightsChecking=OFF;

Specifying table cache

DataDirectory=\\servername\sharename\dictionaryfile.add;ServerTypes=2;MaxTableCloseCache=20;

The number of tables to hold in cache when cursors are opened and closed. Default value is 25.

Use compression

DataDirectory=\\servername\sharename\dictionaryfile.add;ServerTypes=2;Compression=Always;

Possible values are ALWAYS, INTERNET, NEVER or empty string. If left empty the ADS.INI file will control the setting. This parameter is not used with ALS.

Specifying connection protocol

DataDirectory=\\servername\sharename\dictionaryfile.add;ServerTypes=2;CommType=TCP_IP;

Possible values are UDP_IP (default) and IPX.