Developers community number 1 connection string reference

Connection strings 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
Manufacturer Sybase

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
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
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.

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

Advantage ODBC Driver

Type ODBC Driver
Usage
Manufacturer Sybase

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
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.

DataDirectory=\\servername\sharename\dictionaryfile.add;ServerTypes=1;
 
 
Copyright © 2012 ConnectionStrings.com   |   All Rights Reserved   |   Powered by CSAS   |   Send feedback, articles, requests and more connection strings here.