skip to main content
Connection Option Descriptions
  

Try DataDirect Drivers Now

Connection Option Descriptions

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, for example, Password, do not have equivalent options that appear on the GUI. They are in the list of descriptions alphabetically by their attribute names.
The following table lists the connection string attributes supported by the Oracle Wire Protocol driver.
Table 11. Oracle Wire Protocol Attribute Names
Attribute (Short Name)
Default
None
None
None
latest
None
1 (Enabled)
60000
1 (Encrypt Password)
BulkBinaryThreshold (BBT) (Windows, UNIX, and Linux only)
32
BulkCharacterThreshold (BCT) (Windows, UNIX, and Linux only)
-1
BulkLoadBatchSize (BLBS) (Windows, UNIX, and Linux only)
1024
BulkLoadFieldDelimiter (BLFD) (Windows, UNIX, and Linux only)
None
BulkLoadOptions (BLO) (Windows, UNIX, and Linux only)
0
BulkLoadRecordDelimiter (BLRD) (Windows, UNIX, and Linux only)
None
32
0
1 (Enabled)
0 (Disabled)
None
None
None
ConnectionReset (CR) (Windows, UNIX, and Linux only)
0 (Disabled)
0
3
None
None
None
TLSv1.2,TLSv1.1,TLSv1
Empty string
1 (Accepted)
MD5,SHA1,SHA256,SHA384,SHA512
None
1024
0 (Disabled)
None
None
EnableBulkLoad (EBL) (Windows, UNIX, and Linux only)
0 (Disabled)
0 (Disabled)
Note: EnableNcharSupport has been deprecated.
None
1 (Enabled)
0 (Disabled)
0 (Disabled)
Note: EnableTimestampwithTimezone has been deprecated.
None
1 (Accepted)
0 (No Encryption)
No encryption methods are specified. The driver sends a list of all of the encryption methods to the Oracle server.
0 (Non-Atomic)
0 (Connection)
0 (Disabled)
0 (Disabled)
native
None
None
IANAAppCodePage (IACP) (UNIX, Linux, macOS only)
4 (ISO 8559-1 Latin-1)
None
None
0 (Disabled)
None
None
None
LDAPDistinguishedName (LDN) (Windows, UNIX, and Linux only)
None
LoadBalanceTimeout (LBT) (Windows, UNIX, and Linux only)
0
0 (Disabled)
4000
"" (Empty String)
-1
15
None
MaxPoolSize (MXPS) (Windows, UNIX, and Linux only)
100
MinPoolSize (MNPS) (Windows, UNIX, and Linux only)
0
None
None
Pooling (POOL) (Windows, UNIX, and Linux only)
0 (Disabled)
None
PRNGSeedFile (PSF) (UNIX, Linux, macOS only)
/dev/random
PRNGSeedSource (PSS) (UNIX, Linux, macOS only)
0 (File)
0 (Disabled)
None
ProxyHost (PXHN) (Windows, UNIX, and Linux only)
Empty string
ProxyMode (PXM) (Windows, UNIX, and Linux only)
0 (NONE)
ProxyPassword (PXPW) (Windows, UNIX, and Linux only)
Empty string
ProxyPort (PXPT) (Windows, UNIX, and Linux only)
0
ProxyUser (PXU) (Windows, UNIX, and Linux only)
Empty string
0
0 (Ignore Errors)
0 (Disabled)
16384
None
0 (Server Default)
None. If no value is specified for either the SID, Service Name, or TNSNames option, the driver attempts to connect to the ORCL SID by default.
None. If no value is specified for either the SID, Service Name, or TNSNames option, the driver attempts to connect to the ORCL SID by default.
Empty string
0 (Disabled)
0 (Oracle Version Specific)
None. If no value is specified for either the SID, Service Name, or TNSNames option, the driver attempts to connect to the ORCL SID by default.
None
None
1 (Enabled)
1 (Enabled)
2
This section includes the following topics:
* Accounting Info
* Action
* AllowedOpenSSLVersions
* Alternate Servers
* Application Name
* Application Using Threads
* Array Size
* Authentication Method
* Batch Size
* Bulk Binary Threshold
* Bulk Character Threshold
* Bulk Options
* Cached Cursor Limit
* Cached Description Limit
* Catalog Functions Include Synonyms
* Catalog Options
* Client Host Name
* Client ID
* Client User
* Connection Pooling
* Connection Reset
* Connection Retry Count
* Connection Retry Delay
* Credentials Wallet Entry
* Credentials Wallet Path
* Crypto Protocol Version
* CryptoLibName
* Data Integrity Level
* Data Integrity Types
* Data Source Name
* Default Buffer Size for Long/LOB Columns (in Kb)
* Describe at Prepare
* Description
* Edition Name
* Enable Bulk Load
* Enable N-CHAR Support
* Enable Scrollable Cursors
* Enable Server Result Cache
* Enable SQLDescribeParam
* Enable Static Cursors for Long Data
* Enable Timestamp with Timezone
* Encryption Level
* Encryption Method
* Encryption Types
* Failover Granularity
* Failover Mode
* Failover Preconnect
* Fetch TSWTZ as Timestamp
* Field Delimiter
* GSS Client Library
* Host
* Host Name In Certificate
* IANAAppCodePage
* Impersonate User
* Initialization String
* Key Password
* Key Store
* Key Store Password
* LDAP Distinguished Name
* Load Balancing
* LoadBalance Timeout
* LOB Prefetch Size
* Local Timezone Offset
* Lock Timeout
* Login Timeout
* Max Pool Size
* Min Pool Size
* Module
* Password
* Port Number
* Proxy Host
* Proxy Mode
* Proxy Password
* Proxy Port
* Proxy User
* PRNGSeedFile
* PRNGSeedSource
* Procedure Returns Results
* Program ID
* Query Timeout
* Record Delimiter
* Report Codepage Conversion Errors
* Report Recycle Bin
* SDU Size
* Server Name
* Server Process Type
* Service Name
* SID
* SSLLibName
* Support Binary XML
* TCP Keep Alive
* Timestamp Escape Mapping
* TNSNames File
* Trust Store
* Trust Store Password
* Use Current Schema for SQLProcedures
* User Name
* Validate Server Certificate
* Wallet Password
* Wire Protocol Mode