Using Failover on UNIX

Use the unixODBC Driver Manager or the Sybase iAnywhere ODBC Driver Manager to failover on UNIX platform.

1. If you are linking to the unixODBC Driver Manager, edit the datasource template and reinstall the datasource using the unixODBC command line tool:

   #  odbcinst -i -s -f dsn template file

   where dsn template file is the complete path to the Adaptive Server ODBC datasource template file.

2. If you are directly linking to the Adaptive Server ODBC Driver or Sybase iAnywhere ODBC Driver Manager, modify the odbc.ini file.
   This is an example of the odbc.ini datasource template file:

   [sampledsn]
   Driver=Adaptive Server Enterprise
   Server=sampleserver
   Port=4100
   UserID=sa
   Password=
   Database=pubs2
   HASession=1
   SecondaryHost=failoverserver
   SecondaryPort=5000