Enabling Cluster Edition Connection Failover

Set the HASession connection string property to 1 to enable Cluster Edition connection failover.

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.

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