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

Connection Options: Advanced Default
Cursor Positioning for Raiserror 0 - Default
Default Buffer Size for Long/LOB Columns (in Kb) 1024
Distributed Transaction Model 0 - XA Protocol
Initialization String No default value
Report Codepage Conversion Errors 0 - Ignore Errors
XA Open String Parameters No default value
Application Using Threads Enabled
Enable Quoted Identifiers Disabled
Enable Describe Parameter Disabled
Tightly Coupled Distributed Transactions Enabled
TCP Keep Alive Disabled
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.