The connection options described in this section may be used to configure the connection between the application (through the Hybrid Data Pipeline Driver for ODBC) and the Hybrid Data Pipeline connectivity service. Connection options can be supplied in an ODBC data source or .ini file or passed in a connection string using the Driver keyword. They may also be split up such that some are specified in a data source or the .ini file, while others are passed in a connection string. Passing some options in a connection string is common to protect credentials for security reasons.

The connection options in this section are listed alphabetically by the name that appears on the driver setup dialog box or the logon dialog box. The attribute name and short name, which can be used in connection strings, data source files, and .ini file data source sections are listed underneath the GUI name.

In most cases, the GUI name and the option name are the same; however, some exceptions exist. Also, a few connection string attributes do not have equivalent GUI options. They are listed alphabetically by their attribute names.

Option Default
Application Using Threads 1 - Enabled
Client Time Zone None
Crypto Protocol Version None1
Data Source Name None
Data Source Password None
Data Source User None
Default Buffer Size for Long/LOB Columns (in Kb) 1024
Description None
Enable FIPS 0 - Disabled
Enable WChar Support 1 - Enabled
Encryption Method 0 - No Encryption
Host Name In Certificate None
Hybrid Data Pipeline Source None
IANAAppCodePage 4 (ISO 8559-1 Latin-1)
Login Timeout 0 (the connection does not timeout)
Logon Domain None
Max Varchar Size None
Min Long Varchar Size None
Password None
Port Number None
Proxy Host None
Proxy Password None
Proxy User None
Query Timeout 0 (the query does not timeout)
Report Codepage Conversion Errors 0 - Ignore Errors
Service <myserver>:<port>
Transaction Mode  2 - Transactions
Trust Store None
Trust Store Password None
User Name None
Validate Server Certificate 1 - Enabled
Varchar Threshold None
WSRetryCount 3
WSTimeout 120
1 In the Security tab, the default setting is an empty string. However, internally, the default TLSv1,TLSv1.2 is used when no value is entered. This value is a range of protocol versions between TLSv1 and TLSv1.2. The driver uses the highest protocol version supported by Hybrid Data Pipeline in this range.