Connection strings for Sybase Advantage Database Server
Providers for Sybase Advantage Database Server
Community Forums
Find solutions and post questions regarding connection string related issues.
Advantage .NET Data Provider
Type: .NET Framework Class Library
Usage: Advantage.Data.Provider.AdsConnection
Usage: Advantage.Data.Provider.AdsConnection
Manufacturer: Sybase
More info about this class library »
More info about this class library »
Standard remote connection
Data Source=\\myserver\myvolume\mypat\mydd.add;User ID=myUsername;Password=myPassword;ServerType=REMOTE;
Separating the path and catalog parameters
Data Source=\\myserver\myvolume\mypat;Initial Catalog=mydd.add;User ID=myUsername;Password=myPassword;ServerType=REMOTE;
Specifying port
Data Source=\\myserver:9999\myvolume\mypat\mydd.add;User ID=myUsername;Password=myPassword;ServerType=REMOTE;
Read only connection
Data Source=\\myserver\myvolume\mypat\mydd.add;User ID=myUsername;Password=myPassword;ServerType=REMOTE;ReadOnly=TRUE;
Trim spaces from string data
Fields of type String will have trailing white spaced trimmed on retrieval.
Data Source=\\myserver\myvolume\mypat\mydd.add;User ID=myUsername;Password=myPassword;ServerType=REMOTE;TrimTrailingSpaces=TRUE;
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
Type: OLE DB Provider
Usage: Provider=Advantage OLE DB Provider
Usage: Provider=Advantage OLE DB Provider
Manufacturer: Sybase
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.
.NET Framework Data Provider for OLE DB
Type: .NET Framework Wrapper Class Library
Usage: System.Data.OleDb.OleDbConnection
Usage: System.Data.OleDb.OleDbConnection
Manufacturer: Microsoft
More info about this wrapper class library »
More info about this wrapper class library »
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.
Provider=Advantage OLE DB Provider;User ID=adssys;Data Source=MyDataDictionaryPath;Advantage Server Type=ADS_REMOTE_SERVER;
Advantage ODBC Driver
ALS
DataDirectory=\\servername\sharename\dictionaryfile.add;ServerTypes=1;
ADS
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.
.NET Framework Data Provider for ODBC
Type: .NET Framework Wrapper Class Library
Usage: System.Data.Odbc.OdbcConnection
Usage: System.Data.Odbc.OdbcConnection
Manufacturer: Microsoft
More info about this wrapper class library »
More info about this wrapper class library »
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.
DataDirectory=\\servername\sharename\dictionaryfile.add;ServerTypes=1;
Selected Articles