The Advanced tab allows you to specify additional data source settings. The fields are optional unless otherwise noted. On this tab, provide values for the options in the following table; then, click Apply.

Figure 1. Advanced tab

The Advanced Tab of the ODBC PostgreSQL Driver Setup dialog box

Connection Options: Advanced Default
Application Using Threads Enabled
Enable SQLDescribeParam Enabled
Fetch TSWTZ as Timestamp Disabled
Fetch TWFS as Time Disabled
TCP Keep Alive Disabled
Show Selectable Tables Enabled
Fetch Ref Cursor Enabled
Batch Mechanism 3 - Copy
Extended Column MetaData Disabled
Use Declare Fetch Disabled
Enable Keyset Cursors Disabled
Fetch Size 50000
Keyset Cursor Options 0-RowID Columns
Transaction Error Behavior 1-Rollback
XML Describe Type -10 SQL_WLONGVARCHAR
Initialization String No default value
Report Codepage Conversion Errors 0 - Ignore Errors
Call Escape Behavior 2 - Execute Procedure if No Return
Unbounded Numeric Precision -1
Unbounded Numeric Scale -1
Login Timeout 15
Query Timeout 0
Max Char Size No default value
Max Varchar Size No default value
Max Long Varchar Size No default value
Extended Options No default value