The following connection option descriptions are listed alphabetically by the GUI name that appears on the driver Setup dialog box. The connection string attribute name, along with its short name, is listed immediately underneath the GUI name.

In most cases, the GUI name and the attribute name are the same; however, some exceptions exist. If you need to look up an option by its connection string attribute name, please refer to the alphabetical table of connection string attribute names.

Also, a few connection string attributes do not have equivalent options that appear on the GUI. They are in the list of descriptions alphabetically by their attribute names.

Note: The driver does not support specifying values for the same connection option multiple times in a connection string or DSN. If a value is specified using the same attribute multiple times or using both long and short attributes, the connection may fail or the driver may not behave as intended.

The following tables provide a summary of supported connection options by functionality, including their attribute names, short names, and default values.

General options

The following table summarizes general options that can apply to all connections that use data sources.

Table 1. General options
Attribute (Short Name) Default
DataSourceName (DSN) No default value
Database (DB) No default value
Description (n/a) No default value
InterfacesFile (IF) No default value
InterfacesFileServerName (IFSN) No default value
NetworkAddress (NA) No default value

User ID and password options

The following table summarizes options that are required for user ID and password authentication.

Table 2. User ID and password authentication options
Attribute (Short Name) Default
LogonID (UID) No default value
Password (PWD) No default value

Kerberos authentication options

The following table summarizes options that are required for Kerberos authentication.

Table 3. Kerberos authentication options
Attribute (Short Name) Default
AuthenticationMethod (AM) 0 (No Encryption)
GSSClient (GSSC) native
ServicePrincipalName (SPN) No default value

TLS/SSL encryption options

The following table summarizes the connection options used to enable TLS/SSL.

Table 4. TLS/SSL encryption options
Attribute (Short Name) Default
CryptoLibName (CLN) No default value
CryptoProtocolVersion (CPV) TLSv1.3,TLSv1.2
EnableFIPS (EF) 0 (Default provider)
EncryptionMethod (EM) 0 (No Encryption)
HostNameInCertificate (HNIC) No default value
OpenSSLConfigFile (OSSLCNF)

install_dir\drivers\openssl.cnf (Windows)

install_dir/lib/openssl.cnf (UNIX/Linux)
OpenSSLProviderPath (OSSLPP)

install_dir\drivers (Windows)

install_dir/lib (UNIX/Linux)
PRNGSeedFile (PSF) /dev/random
PRNGSeedSource (PSS) 0 (File)
SSLLibName (SLN) No default value
Truststore (TS) No default value
TruststorePassword (TSP) No default value
ValidateServerCertificate (VSC) 1 (Enabled)

Failover options

The following table summarizes the connection options that control how failover works with the driver.
Table 5. Failover options
Attribute (Short Name) Default
AlternateServers (ASRV) No default value
ConnectionRetryCount (CRC) 0
ConnectionRetryDelay (CRD) 3
FailoverGranularity (FG) 0 (Non-Atomic)
FailoverMode (FM)

0 (Connection)
FailoverPreconnect (FP) 0 (Disabled)
LoadBalancing (LB) 0 (Disabled)

Timeout options

The following table summarizes timeout options.

Table 6. Timeout options
Attribute (Short Name) Default
LoginTimeout (LT) 15
QueryTimeout (QT) 0

Pooling options

The following table summarizes connection pooling options.

Table 7. Pooling options
Attribute (Short Name) Default
ConnectionReset (CR) 0 (Disabled)
LoadBalanceTimeout (LBT) 0 (Disabled)
MaxPoolSize (MXPS) 100
MinPoolSize (MNPS) 0
Pooling (POOL) 0 (Disabled)

Bulk options

The following table summarizes DataDirect Bulk Load options.

Table 8. Bulk options
Attribute (Short Name) Default
EnableBulkLoad (EBL) 0 (Disabled)
BulkLoadFieldDelimiter (BLFD) No default value
BulkLoadRecordDelimiter (BLRD) No default value
BulkBinaryThreshold (BBT) 32
BulkLoadBatchSize (BLBS) 1024
BulkCharacterThreshold (BCT) -1

Connection options

The following table summarizes the options provided on the Connection tab of the setup dialog box.

Table 9. Connection options
Attribute (Short Name) Default
ApplicationName (APP) No default value
Charset (CS) No default value
DatabaseList (n/a) No default value
Language (LANG) None (English)
WorkstationID (WKID) No default value

Performance options

The following table summarizes the options that can affect performance.

Table 10. Performance options
Attribute (Short Name) Default
ApplicationUsingThreads (AUT) 1 (Enabled)
ArraySize (AS) 50
DefaultLongDataBuffLen (DLDBL) 1024
EnableBulkLoad (EBL) 0 (Disabled)
EncryptionMethod (EM) 0 (No Encryption)
FailoverMode (FM) 0 (Connection)
OptimizePrepare (OP) 1 (Partial)
PacketSize (PS) 0
Pooling (POOL) 0 (Disabled)
SelectMethod (SM) 0 (Cursor)

Additional options

The following table summarizes additional options.

Table 11. Additional options
Attribute (Short Name) Default
CursorCacheSize (CCS) 1
DistributedTransactionModel (DTM) 0 (XA Protocol)
EnableDescribeParam (EDP) 0 (Disabled)
EnableQuotedIdentifiers (EQI) 0 (Disabled)
ExtendedOptions (XO) No default value
FailoverNetworkAddress (FNA) No default value
FetchTWFSasTime (FTWFSAT) 1 (Enabled)
IANAAppCodePage (IACP) LINUX ONLY 4 (ISO 8559-1 Latin-1)
InitializationString (IS) No default value
KeepAlive (KA) 0 (Disabled)
RaiserrorPositionBehavior (REPB) 0 (Default)
ReportCodepageConversionErrors (RCCE) 0 (Ignore Errors)
TightlyCoupledDistributedTransactions (TCDT) 1 (Enabled)
TruncateTimeTypeFractions (TTF) 0 (Disabled)
XAOpenStringParameters (XAOSP) No default value