skip to main content
Part 2: The 32-Bit/64-Bit Drivers : The SQL Server Wire Protocol Driver : Connection Option Descriptions
  
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 SQL Server Wire Protocol driver.
Table 30. SQL Server Wire Protocol Attribute Names
Attribute (Short Name)
Default
None
0 (Disabled)
1 (Enabled)
None
1 (Enabled)
1 (Encrypt Password)
32
-1
1024
2
None
None
0 (Disabled)
0
3
None
None
None
None
0 (Disabled)
0 (Disabled)
0 (No Encryption)
0 (Non-Atomic)
0 (Connection)
0 (Disabled)
0 (Disabled)
1 (Enabled)
native
None
None
4 (ISO 8559-1 Latin-1)
None
None
0
0 (Disabled)
None
None
100
0
-1
None
0 (disabled)
1433
0
0 (Ignore Errors)
0 (Disabled)
None
None
None
1 (enabled)
None
-10
This section includes the following topics:
* Alternate Servers
* Always Report Trigger Results
* AnsiNPW
* Application Name
* Application Using Threads
* Authentication Method
* Batch Size
* Bulk Binary Threshold
* Bulk Character Threshold
* Bulk Options
* Connection Pooling
* Connection Reset
* Connection Retry Count
* Connection Retry Delay
* Data Source Name
* Database
* Description
* Domain
* Enable Bulk Load
* Enable Quoted Identifiers
* Encryption Method
* Failover Granularity
* Failover Mode
* Failover Preconnect
* Fetch TSWTZ as Timestamp
* Fetch TWFS as Time
* Field Delimiter
* GSS Client Library
* Host Name
* Host Name In Certificate
* IANAAppCodePage
* Initialization String
* Language
* Load Balance Timeout
* Load Balancing
* Login Timeout
* Max Pool Size
* Min Pool Size
* Packet Size
* Password
* Port Number
* Query Timeout
* Record Delimiter
* Report Codepage Conversion Errors
* Truststore
* Truststore Password
* Use Snapshot Transactions
* User Name
* Validate Server Certificate
* Workstation ID
* XML Describe Type