By default, clients connect to the port listed in the query line of the server entry. If that port is not available (because that server has failed-over), the client connects to the server listed in the hafailover line of the server entry in sql.ini. Here is a sample sql.ini file for a primary companion named MONEY1 and a secondary companion named PERSONNEL1:
[MONEY1] query=TCP,FN1,9835 master=TCP,FN1,9835 hafailover=PERSONNEL1 [PERSONNEL1] query=TCP,HUM1,7586 master=TCP,HUM1,7586 hafailover=MONEY1
Use dsedit to add entries to the sql.ini file. If sql.ini entries already exist, modify them to work for fail over.
See Installing Adaptive Server and OmniConnect for Windows NT for more information about dsedit.
Copyright © 2005. Sybase Inc. All rights reserved. |
![]() |