Connection strings for Sybase Advantage Database Server
Advantage .NET Data Provider
Usage Advantage.Data.Provider.AdsConnection
Manufacturer Sybase
Standard remote connection
Separating the path and catalog parameters
Specifying port
Read only connection
Trim spaces from string data
Fields of type String will have trailing white spaced trimmed on retrieval.
If FALSE is specified, then trailing white space is maintained on the values when they are retrieved. This means that a fixed length String field with a width of 10, for example, will always return 10 characters when the value is retrieved; it is padded with as many spaces as necessary.
Advantage OLE DB Provider
Usage Provider=Advantage OLE DB Provider
Manufacturer Sybase
Remote Server
The value "Advantage.OLEDB.1" is also applicable for the provider key, the result will be the same.
Local Server
Using FoxPro tables
If not specifying the TableType value the default value of "ADS_ADT" will be used.
Show deleted records
Please note that the ShowDeleted option is only available with FoxPro tables, ie TableType="ADS_CDX".
Using OEM characters in tables
If not specifying the CharType value the default value of "ADS_ANSI" will be used.
Ignoring rights
If not specifying the SecurityMode value the default value of "ADS_CHECKRIGHTS" will be used.
.NET Framework Data Provider for OLE DB
Usage System.Data.OleDb.OleDbConnection
Manufacturer Microsoft
Bridging to Advantage OLE DB Provider
This is just one connection string sample for the wrapping OleDbConnection class that calls the underlying OLEDB provider. See respective OLE DB provider for more connection strings to use with this class.
Advantage ODBC Driver
Usage
Manufacturer Sybase
ALS
ADS
Internet
Try ADS, if fail; try ALS
Ignore client rights
Specifying table cache
The number of tables to hold in cache when cursors are opened and closed. Default value is 25.
Use compression
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
Possible values are UDP_IP (default) and IPX.
.NET Framework Data Provider for ODBC
Usage System.Data.Odbc.OdbcConnection
Manufacturer Microsoft
Bridging to Advantage ODBC Driver
This is just one connection string sample for the wrapping OdbcConnection class that calls the underlying ODBC Driver. See respective ODBC driver for more connection strings to use with this class.