skip to main content
Configuring the ODBC Client : Configuring Connection Failover for the ODBC Client : Specifying Alternate Servers : odbc.ini File Example
 
odbc.ini File Example
To configure the 32-bit ODBC Client installed on a Solaris machine to use connection failover in conjunction with some of its optional features in your odbc.ini file, you could set the following connection string attributes:

[ODBC Data Sources]
SALESDB=DataDirect OpenAccess SDK 8.1
[SALESDB]
Driver=path_of_installdir/lib/ivoa26.so
Description=DataDirect OpenAccess SDK 8.1
Host=
Port=
UseLDAP=0
DistinguishedName=
AlternateServers=(Host=server1:Port=19986:ServerDataSource=SDSN1,Host=server2:Port=19986:ServerDataSource=SDSN2,Host=server3:Port=19986:ServerDataSource=SDSN3)
...
ConnectionRetryCount=4
ConnectionRetryDelay=5
...
LoadBalancing=0
...
Specifically, this odbc.ini configuration tells the ODBC Client to use two alternate servers as connection failover servers, to attempt to connect four additional times if the initial attempt fails, to wait five seconds between attempts, and to try the primary and alternate servers in sequential order (do not use load balancing).