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.

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 table lists the connection string attributes supported by the Oracle Wire Protocol driver.

Table 1. Oracle Wire Protocol Attribute Names
Attribute (Short Name) Default
AccountingInfo (AI) None
Action (ACT) None
AlternateServers (ASRV) None
ApplicationName (AN) None
ApplicationUsingThreads (AUT) 1 (Enabled)
ArraySize (AS) 60000
AuthenticationMethod (AM) 1 (Encrypt Password)
BatchFailureReturnsError (BFRE) 0 (Disabled)
BindParamsAsUnicode (BPAU) 0 (Disabled)
BulkBinaryThreshold (BBT) 32
BulkCharacterThreshold (BCT) -1
BulkLoadBatchSize (BLBS) 1024
BulkLoadFieldDelimiter (BLFD) , (comma)
BulkLoadOptions (BLO) 0
BulkLoadRecordDelimiter (BLRD) None
CachedCursorLimit (CCL) 32
CachedDescriptionLimit (CDL) 0
CatalogIncludesSynonyms (CIS) 1 (Enabled)
CatalogOptions (CO) 0 (Disabled)
ClientHostName (CHN) None
ClientID (CID) None
ClientUser (CU) None
ConnectionReset (CR) 0 (Disabled)
ConnectionRetryCount (CRC) 0
ConnectionRetryDelay (CRD) 3
CredentialsWalletEntry (CWE) None
CredentialsWalletPassword (CWPWD) None
CredentialsWalletPath (CWPATH) None
CryptoProtocolVersion (CPV) TLSv1.3,TLSv1.2
CryptoLibName (CLN) Empty string
DataIntegrityLevel (DIL) 1 (Accepted)
DataIntegrityTypes (DIT) MD5,SHA1,SHA256,SHA384,SHA512
DataSourceName (DSN) None
DefaultLongDataBuffLen (DLDBL) 1024
DescribeAtPrepare (DAP) 0 (Disabled)
Description (n/a) None
EditionName (EN) None
EnableBulkLoad (EBL) 0 (Disabled)
EnableDescribeParam (EDP) 0 (Disabled)
EnableFIPS (EF) 0 (Default provider)
EnableNcharSupport (ENS)
Note: EnableNcharSupport has been deprecated.
None
EnableScrollableCursors (ESC) 1 (Enabled)
EnableServerResultCache (ESRC) 0 (Disabled)
EnableStaticCursorsForLongData (ESCLD) 0 (Disabled)
EnableTimestampwithTimezone (ETWT)
Note: EnableTimestampwithTimezone has been deprecated.
None
EncryptionLevel (EL) 1 (Accepted)
EncryptionMethod (EM) 0 (No Encryption)
EncryptionTypes (ET) No encryption methods are specified. The driver sends a list of all of the encryption methods to the Oracle server.
Entra Access Token (EAT) None
FailoverGranularity (FG) 0 (Non-Atomic)
FailoverMode (FM) 0 (Connection)
FailoverPreconnect (FP) 0 (Disabled)
FetchTSWTZasTimestamp (FTSWTZAT) 0 (Disabled)
GSSClient (GSSC) native
HostName (HOST) None
HostNameInCertificate (HNIC) None
IANAAppCodePage (IACP) (UNIX and Linux only) 4 (ISO 8559-1 Latin-1)
ImpersonateUser (IU) None
InitializationString (IS) None
KeepAlive (KA) 0 (Disabled)
KeyPassword (KP) None
Keystore (KS) None
KeystorePassword (KSP) None
LDAPCryptoProtocolVersion (LDAPCPV) TLSv1.3,TLSv1.2
LDAPDistinguishedName (LDAPDN) None
LDAPEncryptionMethod (LDAPEM) 0
LDAPKeyStore (LDAPKS) None
LDAPTrustStore (LDAPTS) None
LDAPValidateServerCertificate (LDAPVSC) 1
LoadBalanceTimeout (LBT) 0
LoadBalancing (LB) 0 (Disabled)
LOBPrefetchSize (LPS) 4000
LocalTimezoneOffset (LTZO) "" (Empty String)
LockTimeout (LTO) -1
LoginTimeout (LT) 15
LogonID (UID) None
MaxPoolSize (MXPS) 100
MinPoolSize (MNPS) 0
Module (MOD) None
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)
Password (PWD) None
Pooling (POOL) 0 (Disabled)
PortNumber (PORT) None
PRNGSeedFile (PSF) (UNIX and Linux only) /dev/random
PRNGSeedSource (PSS) (UNIX and Linux only) 0 (File)
ProcedureRetResults (PRR) 0 (Disabled)
ProgramID (PID) None
ProxyHost (PXHN) Empty string
ProxyMode (PXM) 0 (NONE)
ProxyPassword (PXPW) Empty string
ProxyPort (PXPT) 0
ProxyUser (PXU) Empty string
QueryTimeout (QT) 0
ReportCodepageConversionErrors (RCCE) 0 (Ignore Errors)
ReportRecycleBin (RRB) 0 (Disabled)
SDU Size 16384
ServerName (SRVR) None
ServerType (ST) 0 (Server Default)SDUSize (SDU)
ServiceName (SN) 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.
SID (SID) 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.
SSLLibName (SLN) Empty string
SupportBinaryXML (SBX) 0 (Disabled)
TimestampEscapeMapping (TEM) 0SDUSize (Oracle Version Specific)
TNSNamesFile (TNF) 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.
Truststore (TS) None
TruststorePassword (TSP) None
UseCurrentSchema (UCS) 1 (Enabled)
ValidateServerCertificate (VSC) 1 (Enabled)
WireProtocolMode (WPM) 2

This section includes the following topics: