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.

For example:

Application Using Threads

Attribute

ApplicationUsingThreads (AUT)

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 Amazon Redshift Wire Protocol driver.

Table 1. Amazon Redshift Wire Protocol Driver Attribute Names
Attribute (Short Name) Default
AlternateServers (ASRV) None
ApplicationUsingThreads (AUT) 1 (Enabled)
AuthenticationMethod (AM) 0 (Basic)
AutoCreate (ATCRT) 0
AWSCluster (ACLS) None
AWSDBGroup (ADG) None
AWSDBUser (ADU) None
AWSRegion (ARG) None
AzureClientID (AZCLID) None
AzureClientSecret (AZCLISEC) None
AzureTenantID (AZTNTID) None
ConnectionReset (CR) 0 (Disabled)
ConnectionRetryCount (CRC) 0
ConnectionRetryDelay (CRD) 3
CryptoLibName (CLN) Empty string
CryptoProtocolVersion (CPV) TLSv1.2,TLSv1.1,TLSv1
Database (DB) None
DataSourceName (DSN) None
Description (n/a) None
EnableDescribeParam (EDP) 1 (Enabled)
EnableFIPS (EF) 0 (Default provider)
EncryptionMethod (EM) 0 (No Encryption)
ExtendedColumnMetaData (ECMD) 0 (Disabled)
FailoverGranularity (FG) 0 (Non-Atomic)
FailoverMode (FM) 0 (Connection)
FailoverPreconnect (FP) 0 (Disabled)
FetchTSWTZasTimestamp (FTSWTZAT) 0 (Disabled)
HostName (HOST) None
HostNameInCertificate (HNIC) None
IANAAppCodePage (IACP) (UNIX ONLY) 4 (ISO 8559-1 Latin-1)
InitializationString (IS) None
KeepAlive (KA) 0 (Disabled)
KeyPassword (KP) None
Keystore (KS) None
KeystorePassword (KSP) None
LoadBalanceTimeout (LBT) 0
LoadBalancing (LB) 0 (Disabled)
LoginTimeout (LT) 15
LogonID (UID) None
Max Char Size None
MaxPoolSize (MXPS) 100
MaxVarcharSize (MVS) None
MinPoolSize (MNPS) 0
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) 5439
ProxyHost (PXHN) Empty String
ProxyMode (PXM) 0
ProxyPassword (PXPW) Empty String
ProxyPort (PXPT)

0
ProxyUser (PXU) Empty String
QueryTimeout (QT) 0
ReportCodepageConversionErrors (RCCE) 0 (Ignore Errors)
ShowSelectableTables (SST) Enabled
SSLLibName (SLN) Empty string
TransactionErrorBehavior (TEB) 1 (Rollback)
Truststore (TS) None
TruststorePassword (TSP) None
ValidateServerCertificate (VSC) 1 (Enabled)

This section includes the following topics: