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 SQL Server Wire Protocol driver.

Table 1. SQL Server Wire Protocol Attribute Names
Attribute (Short Name) Default
AEKeyCacheTTL (AETTL) -1 (No expiration)
AEKeystoreClientSecret (AEKSCS) None
AEKeyStoreLocation (AEKSL) None
AEKeystorePrincipalId (AEKSPI) None
AEKeyStoreSecret (AEKSS) None
AlternateServers (ASRV) None
AlwaysReportTriggerResults (ARTR) 0 (Disabled)
AnsiNPW (ANPW) 1 (Enabled)
ApplicationIntent (AI)

0 (READWRITE)
ApplicationName (APP) None
ApplicationUsingThreads (AUT) 1 (Enabled)
AuthenticationMethod (AM) 1 (Encrypt Password)
BulkBinaryThreshold (BBT) 32
BulkCharacterThreshold (BCT) -1
BulkLoadBatchSize (BLBS) 1024
BulkLoadOptions (BLO) 2
BulkLoadFieldDelimiter (BLFD) None
BulkLoadRecordDelimiter (BLRD None
BulkLoadThreshold (BLTH) 2
ColumnEncryption (CE) Disabled
ConnectionReset (CR) 0 (Disabled)
ConnectionRetryCount (CRC) 0
ConnectionRetryDelay (CRD) 3
CryptoLibName (CLN) Empty string
CryptoProtocolVersion (CPV) TLSv1.3, TLSv1.2
Database (DB) None
DataSourceName (DSN) None
Description (n/a) None
Domain (DOM) None
EnableBulkLoad (EBL) 0 (Disabled)
EnableFIPS (EF) 0 (Default provider)
EnableQuotedIdentifiers (EQI) 0 (Disabled)
EnableReplicationUser (ERU) 0 (Disabled)
EnableServersideCursors (ESSC) 1 (Enable All Except Forward Only)
EncryptionMethod (EM) 0 (None)
FailoverGranularity (FG) 0 (Non-Atomic)
FailoverMode (FM) 0 (Connection)
FailoverPreconnect (FP) 0 (Disabled)
FetchTSWTZasTimestamp (FTSWTZAT) 0 (Disabled)
FetchTWFSasTime (FTWFSAT) 1 (Enabled)
GSSClient (GSSC) native
HostName (HOST) None
HostNameInCertificate (HNIC) None
IANAAppCodePage (IACP) (UNIX ONLY) 4 (ISO 8559-1 Latin-1)
InitializationString (IS) None
KeepAlive (KA) 0 (Disabled)
KeepConnectionActive (KCA) 0 (Disabled)
Language (LANG) None
LoadBalanceTimeout (LBT) 0
LoadBalancing (LB) 0 (Disabled)
LoginTimeout (LT) None
LogonID (UID) None
MaxPoolSize (MXPS) 100
MinPoolSize (MNPS) 0
MultiSubnetFailover (MSF) 0 (Disabled)
OpenSSLConfigFile (OSSLCNF)

install_dir\drivers (Windows)

install_dir/lib (UNIX/Linux)
OpenSSLProviderPath (OSSLPP)

install_dir\drivers (Windows)

install_dir/lib (UNIX/Linux)
PacketSize (PS) -1
Password (PWD) None
Pooling (POOL) 0 (disabled)
PortNumber (PORT) 1433
PRNGSeedFile (PSF) UNIX\Linux only /dev/random
PRNGSeedSource (PSS) UNIX\Linux only 0 (File)
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)
SSLLibName (SLN) Empty string
SnapshotSerializable (SS) 0 (Disabled)
SocketIdleTimeCheckInterval (SITCI) 1500 (seconds)
SuppressFabricWarnings 1 (enabled)
Truststore (TS) None
TruststorePassword (TSP) None
ValidateServerCertificate (VSC) 1 (enabled)
WorkstationID (WSID) None
XMLDescribeType (XDT) -10

This section includes the following topics: