ODBC Connection Properties

The following table lists connection properties alphabetically, with links to the appropriate description, and lists the default values.

Table 134. ODBC Connection Properties
Property	Default
Application Using Threads	1 (Enabled)
Client Time Zone	Empty string (use system time zone)
Data Source Name	None
Data Source Password	None
Data Source User	None
Default Buffer Size for Long/LOB Columns (in Kb)	1024
Description	None
Enable SSL	0 - Disabled
Enable WChar Support	1 - Enabled
Host Name In Certificate	None
Hybrid Data Pipeline Source	None
IANAAppCodePage	4 (ISO 8559-1 Latin-1)
Login Timeout	0
Logon Domain	None
Max Varchar Size	None
Min Long Varchar Size	None
Password	None
Port Number	None
Proxy Host	Empty string
Proxy Password	Empty string
Proxy User	Empty string
Proxy User	Empty string
Query Timeout	0 (the query does not timeout)
Report Codepage Conversion Errors	0 - Ignore Errors
Service	<myserver>:<port>
Transaction Mode	2 - Transactions
Trust Store	None
Trust Store Password	None
User Name	Empty string
Validate Server Certificate	1 - Enabled
Varchar Threshold	None
WSRetryCount	3
WSTimeout	120