Enabling Connection Failover Using the Adaptive Server ODBC Driver or the Sybase iAnywher ODBC Driver Manager

Use the Adaptive Server Driver Manager or the Sybase iAnywhere ODBC Driver Manager to enable connection failover.

If you are directly linking to the Adaptive Server ODBC Driver or the Sybase iAnywhere ODBC Driver Manager, modify the odbc.ini file to add the alternate servers.

For example:

ODBC Data Source UserID=sa
Password= Driver=Adaptive
Server Enterprise Server=sampleserver
Port=4100
Database=pubs2
UseCursor=1
HASession=1
AlternateServers=server2:port2,server3:port3;

Note: The list of alternate servers specified in the GUI or 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.