To ensure continuous, uninterrupted access to data, the DataDirect Connect Series for ODBC drivers provide the following levels of failover protection, listed from basic to more comprehensive:
• Connection failover provides failover protection for new connections only. The driver fails over new connections to an alternate, or backup, database server if the primary database server is unavailable, for example, because of a hardware failure or traffic overload. If a connection to the database is lost, or dropped, the driver does not fail over the connection. This failover method is the default.
• Extended connection failover provides failover protection for new connections and lost database connections. If a connection to the database is lost, the driver fails over the connection to an alternate server, preserving the state of the connection at the time it was lost, but not any work in progress.
• Select Connection failover provides failover protection for new connections and lost database connections. In addition, it provides protection for Select statements that have work in progress. If a connection to the database is lost, the driver fails over the connection to an alternate server, preserving the state of the connection at the time it was lost and preserving the state of any work being performed by Select statements.Regardless of the failover method you choose, you must configure one or multiple alternate servers using the Alternate Servers connection option. See Guidelines for Primary and Alternate Servers for information about primary and alternate servers.
![]() |
© 2013 Progress Software Corporation and/or its subsidiaries or affiliates. |