The Advanced tab contains the following fields:

Advanced tab
Connection Options: Advanced Initial Default Value
Application Using Threads Enabled
Login Timeout 0
Query Timeout 0
Report Codepage Conversion Errors 0 - Ignore Errors
Transaction Mode 2 - Transactions
Client Time Zone None. The driver uses the client time zone, based on the system-specific time zone settings.
Enable WChar Support Enabled
Default Buffer Size for Long/LOB Columns (in Kb) 1024
Max Varchar Size None
Varchar Threshold None
Min Long Varchar Size None

Extended Options

For Extended Options, you may enter a semi-colon separated list of connection options and their values. Use this option to set the value of undocumented connection options that are provided by Progress DataDirect technical support. You can also add the WorkAround connection option in the Extended Options string, for example: 

Workaround=9;Option1=value [;Option2=value;]

If the Extended Options string contains option values that are also set in the setup dialog or data source, the values of the options specified in the Extended Options string take precedence. However, connection options that are specified on a connection string override any option value specified in the Extended Options string.