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 MySQL Driver Setup dialog box

Connection Options: Advanced Default
Application Using Threads Enabled
Enable SQLDescribeParam Disabled
Interactive Client Disabled
Treat Binary Data as Character Data Disabled
TCP Keep Alive Disabled
Report Codepage Conversion Errors 0 - Ignore Errors
Default Buffer Size for Long/LOB Columns (in Kb) 1024
Login Timeout 15
Query Timeout 0
Batch Mechanism 2 (MultiRowInsert)
Extended Options Type a semi-colon separated list of connection options and their values. Use this configuration option to set the value of undocumented connection options that are provided by Progress DataDirect Technical Support. You can include any valid connection option in the Extended Options string, for example:
NetworkTimeout=0;UndocumentedOption1=value [;UndocumentedOption2=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.