A Connection String Example
- Last Updated: April 25, 2024
- 1 minute read
- DataDirect Connectors
- ODBC
- Cloudera Impala 7.1
- dBase 7.1
- Flat files/Text 7.1
- MySQL 7.1
- Pervasive (Btrieve) 7.1
- XML 7.1
- Documentation
A Connection String Example
The following connection string configures the Sybase Wire Protocol driver to use connection failover in conjunction with some of its optional features.
DSN=AcctSybaseServer;AlternateServers=(NetworkAddress=123.456.78.90,5000:
Database=AccountingSybaseServer,NetworkAddress=098.765.43.21,5000:Database=Accounting);
ConnectionRetryCount=4;ConnectionRetryDelay=5;LoadBalancing=1;FailoverMode=0
Specifically, this connection string configures the driver 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, to try the primary and alternate servers in a random order, and to attempt reconnecting on new connections only. The additional connection information required for the alternate servers is specified in the data source AcctSybaseServer.