Tuesday, July 10, 2012

Connection strings for Sybase Advantage Database Server

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;

Share : Connection strings for Sybase Advantage Database Server

Related Posts

Connection strings for Sybase Advantage Database Server
4/ 5
Oleh