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.

Table 1. General options
Attribute (Short Name) Default
AccountString (AS) No default value
CharacterSet (CS) ASCII
Database (DB) No default value
DataSourceName (DSN) No default value
Description (n/a) No default value
DBCName List No default value
DBCName (DBCN) No default value
IntegratedSecurity (IS) 0 (Disabled)
PortNumber (PORT) 1025

Terada 1 and Teradata 2 authentication options

The following table summarizes options that are required for TD1 and TD2 security mechanism.

Table 2. Authentication options
Attribute (Short Name) Default
AuthenticationPassword (AP) No default value
AuthenticationUserId (AUI) No default value
SecurityMechanism (SECM) No default value

LDAP authentication options

The following table summarizes options that are required for the ldap security mechanism.

Table 3. Authentication options
Attribute (Short Name) Default
AuthenticationDomain (AD) No default value
AuthenticationUserId (AUI) No default value
SecurityMechanism (SECM) No default value
TDProfile (TDP) No default value
TDRole (TDR) No default value
TDUserName (TDUN) No default value

NTLM authentication options

The following table summarizes options that are required for the NTLM security mechanism.

Table 4. Authentication options
Attribute (Short Name) Default
AuthenticationDomain (AD) No default value
AuthenticationUserId (AUI) No default value
SecurityMechanism (SECM) No default value

Kerberos authentication options

The following table summarizes options that are required for the kerberos security mechanism.

Table 5. Authentication options
Attribute (Short Name) Default
AuthenticationPassword (AP) No default value
AuthenticationUserId (AUI) No default value
SecurityMechanism (SECM) No default value

No authentication options

The following table summarizes options that are required if the user selects no security mechanism.

Table 6. Authentication options
Attribute (Short Name) Default
SecurityMechanism (SECM) No default value
UserID (UID) No default value

Additional options

The following table summarizes additional configuration options.

Table 7. Additional options
Attribute (Short Name) Default
EnableDataEncryption (EDE) 0 (Disabled)
EnableExtendedStmtInfo (EESI) 0 (Disabled)
EnableLOBs (EL) 1 (Enabled)
EnableReconnect (ER) 0 (Disabled)
IANAAppCodePage (IACP) UNIX/Linux only 4 (ISO 8559-1 Latin-1)
LoginTimeout (LTO) 20
MapCallEscapeToExec (MCETE) 0 (Disabled)
MaxRespSize (MRS) 8192
PrintOption (PO)

0 (No)
ProcedureWithSPLSource (PWSS)

1 (Yes)
ReportCodepageConversionErrors (RCCE) 0 (Ignore Errors)
ShowSelectableTables (SST) 1 (Enabled)