Advanced tab

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.

Connection Options: Advanced	Default
Add to Create Table	No default value
Alternate ID	No default value
Catalog Schema	No default value
Default Isolation Level	1 - READ_COMMITTED
Character Set for CCSID 65535	0
Report Codepage Conversion Errors	0 - Ignore Errors
Application Using Threads	Enabled
Use Current Schema for Catalog Functions	Disabled
With Hold Cursors	Enabled
TCP Keep Alive	Disabled
Fetch Time Stamp With Time Zone as Timestamp	Disabled
XML Describe Type	-10 - SQL_WLONGVARCHAR
Package Name Prefix	DD
Login Timeout	15
Query Timeout	0
Current Function Path	No default value
Concurrent Access Resolution	0 - Automatic
Varchar Threshold	No default value
Min Long Varchar Size	No default value
Extended Options	No default value

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.