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

Connection Options: Advanced Default
Cursor Positioning for Raiserror 0 - Default
Default Buffer Size for Long Columns (in KB) 1024
Initialization String No default value
Report Codepage Conversion Errors 0 - Ignore Errors
Application Using Threads Enabled
Truncate Time Type Fractions Disabled
Fetch TWFS as Time Enabled
Login Timeout 15
Query Timeout 0
Extended Options No default value

Windows icon Translate: Click Translate to display the Select Translator dialog box, which lists the translators specified in the ODBC Translators section of the Registry. Progress DataDirect provides a translator named OEM to ANSI that translates your data from the IBM PC character set to the ANSI character set.

Select a translator; then, click OK to close this dialog box.