skip to main content
Using the ODBC Client : Using Connection Retry
 

Using Connection Retry

Connection retry defines the number of times the driver attempts to connect to the primary OpenAccess SDK Server in a client/server configuration and, if configured, alternate OpenAccess SDK Servers after the initial unsuccessful connection attempt. Connection retry can be an important strategy for system recovery. For example, suppose you have a power failure in which both the OpenAccess SDK Client and the OpenAccess SDK Server fail. When the power is restored and all computers are restarted, the OpenAccess SDK Client may be ready to attempt a connection before the OpenAccess SDK Server has completed its startup routines. If connection retry is enabled, the client application can continue to retry the connection until a connection is successfully accepted by the OpenAccess SDK Server.
Connection retry can be used in environments that have only one server or can be used as a complementary feature with connection failover in environments with multiple OpenAccess SDK Servers.
Using connection options, you can specify the number of times the driver attempts to connect and the time in seconds between connection attempts. For details on configuring connection retry, see Configuring Connection Failover.