To enable Cluster Edition connection failover, set the HASession connection string property to 1. For example:
Data Source=server1;Port=port1;User ID=sa;Password=; Initial Catalog=sdc;HASession=1; AlternateServers=server2:port2,...,serverN:portN;
In this example, Data Source defines the primary server and port. ADO.NET Provider by Sybase attempts to establish connection to the primary server first and, if unsuccessful, goes through the servers listed in Alternate Servers until a connection is established or until the end of the list is reached.
The list of alternate servers specified in the connection
string is used only during initial connection. After the connection
is established with any available instance, and if the client supports
high availability, the client receives an updated list of the best
possible failover targets from the server. This new list overrides
the specified list.
