ODBC provides a method for specifying connection information via a connection string and the SQLDriverConnect API. This section provides examples of connection strings configured to use common features and functionality. You can modify and/or combine these examples to create a connection string for your environment.

In addition to the connection strings for DSN-less connections demonstrated in this section, the driver supports DSN and File DSN connection strings. See "Using a connection string" for syntax and detailed information for supported connection string types.

Note: The options and values described in this section apply to all configuration methods.

User ID and password authentication

This string includes the options used to connect using user ID and password authentication.

DRIVER=DataDirect 8.0 Progress OpenEdge Wire Protocol;HostName=MyOpenEdgeServer;
       PortNumber=20931;Database=MyDatabase;LogonID=jsmith;Password=secret;

For more information on these options and values, see Authentication.

Connection failover

This string includes the properties used to connect to using connection failover. 
DRIVER=DataDirect 8.0 Progress OpenEdge Wire Protocol;HostName=MyOpenEdgeServer;
       PortNumber=20931;Database=MyDatabase;
       AlternateServers=(HostName=MyAltServer:PortNumber=20932:Database=MyAltDB,
       HostName=MyBackUpServer:PortNumber=20933:Database=MyBackUpDB);
       ConnectionRetryCount=4;ConnectionRetryDelay=5;LoadBalancing=1;
       LogonID=jsmith;Password=secret;
For more information on these options and values, see Failover support.

TLS/SSL server authentication

This string configures the driver to use the TLS/SSL server authentication method. In this configuration, since ValidateServerCertificate=1, the driver validates the certificate sent by the server and the host name specified by HostNameInCertificate.

DRIVER=DataDirect 8.0 Progress OpenEdge Wire Protocol;HostName=MyOpenEdgeServer;
       PortNumber=20931;Database=MyDatabase;EncryptionMethod=1;
       HostNameInCertificate=MySubjectAltName;Truststore=TrustStoreName;
       TruststorePassword=TSXYZZY;ValidateServerCertificate=1;LogonID=jsmith;
       Password=secret;
For more information on these options and values, see TLS/SSL encryption.