Specifying Alternate Servers

To configure connection failover, you specify a list of alternate database servers that are tried at connection time if the primary OpenAccess SDK Server is not accepting connections. To do this, use the Alternate Servers (AlternateServers) connection option. Connection attempts continue until a connection is successfully established or until all the database servers in the list have been tried once (the default).

On Windows, you can configure a data source to use connection failover on the Failover tab of the driver’s Setup dialog box. See for details.

On Linux and UNIX, you can configure a data source to use connection failover by modifying your system information file (odbc.ini). See odbc.ini File Example and odbc64.ini File Example for details.

On Linux, UNIX, and Windows, you can use a connection string to direct the driver to use connection failover. See Connection String Example for details.