Edit the client’s sql.ini file to connect over multiple networks by creating multiple “query” entries, one for each network to which the client will connect. For example, the server “SERVER99” has the following “query” services in its sql.ini entry:
SERVER99 query = NLWNSCK,mercury,1234
query = NLWNSCK,plato,9876
query = NLMSNMP,\\plato\pipe\sql\query
query = NLNWLINK,my_mercury_spx
An Open Client application tries to connect first to the server at “mercury,1234.” If that attempt fails, it tries the server at “plato,9876.” If that attempt fails, it tries the server at “\\plato\pipe\sql\query” using the Named Pipes protocol. As a final attempt, it tries the server at “my_mercury_spx” using the IPX/SPX protocol. If the final attempt fails, Open Client returns an error.
