skip to main content
Connecting Applications to the Connectivity Service : Connection Properties : Optional Connection Properties : Advanced Tab Options

Try DataDirect Cloud Now
Advanced Tab Options
The following table describes fields in the Advanced tab of the ODBC Cloud Driver Setup dialog box, lists the initial default values, and provides the long and short name of the corresponding property. The long name of properties can be set in the Windows registry or in a .ini file, as described in Configuring a Data Source in the System Information File. The short name of properties can be passed in connection strings.
The Advanced tab contains the following fields:
The Advanced tab of the ODBC Cloud Driver Setup dialog
Table 4. Advanced Tab Options
Field NameProperty Name (Short name)
Initial Default Value
Application Using Threads 
ApplicationUsingThreads  (AUT
If selected or set to 1, the ODBC driver works with single-threaded and multi-threaded applications. A value of 0 disables multi-threading. For more information, see Application Using Threads .
Login Timeout
LoginTimeout (LT
The number of seconds the ODBC driver waits for a connection to be established before returning control to the application and generating a timeout error. A value of -1 or 0 prevents timeouts. For more information, see Login Timeout .
Query Timeout
QueryTimeout (QT
The number of seconds before timeout for all statements that are created by a connection. A value of zero prevents a query from timing out. For more information, see Query Timeout.
Report Codepage Conversion Errors
ReportCodepageConversionErrors (RCCE
Determines what will happen if a character cannot be converted from one character set to another, allowed values are:
*0 (Ignore Errors), the driver substitutes 0x1A for each character that cannot be converted and does not return a warning or error
*1 (Return Error), the driver returns an error instead of substituting 0x1A for unconverted characters.
*2 (Return Warning), the driver substitutes 0x1A for each character that cannot be converted and returns a warning.
For more information, see Report Codepage Conversion Errors.
0 - Ignore Errors
Transaction Mode
TransactionMode (TM)
If set to 1 - Ignore, the data source does not support transactions and the driver always operates in auto-commit mode. If set to 0 - No Transactions, the data source and the driver do not support transactions. For more information, see Transaction Mode.
0 - No Transactions
Client Time Zone
ClientTimeZone CTZ 
Specifies a time zone for time and timestamp values that will be applied by the data store. The driver by default attempts to determine the timezone of the client. If it can not determine that timezone automatically, specify the client time zone to use by setting a value for ClientTimeZone. The format is:
<timezone>,<+ or ->HH:MM<D>
where D specifies to account for daylight savings time. For example:
For more information see Client Time Zone.
empty (the driver uses the client time zone, based on the system-specific time zone settings)
Enable WChar Support
EnableWCharSupport EWS
Specifies whether the driver maps character data to the the ODBC Unicode data types, such as WCHAR, WVARCHAR, or WLONGVARCHAR. When using an application that does not support Unicode data types, disable this option. The driver then maps character data to an ANSI Char type, such as CHAR, VARCHAR, or LONGVARCHAR.
Default Buffer Size for Long/LOB Columns (in Kb)
DefaultLongDataBufLen DLBL)
Specifies the maximum length of data (in Kb) the driver can send using the SQL_DATA_AT_EXEC parameter.
Max Varchar Size
MaxVarcharSize (MVS)
Specifies the maximum size of columns of type SQL_VARCHAR that the driver describes through result set descriptions and catalog functions.
Allowed value is a positive integer from 1 to x where x is the maximum size of the SQL_VARCHAR data type. If you leave the field empty, the actual size of the columns from the database is persisted to the application.
Varchar Threshold
Specifies the threshold at which the driver describes columns of the data type SQL_VARCHAR as SQL_LONGVARCHAR. If the size of the SQL_VARCHAR column exceeds the value specified, the driver describe the column as SQL_LONGVARCHAR when calling SQLDescribeCol and SQLColumns. This option allows you to fetch columns that would otherwise exceed the upper limit of the SQL_VARCHAR type for some third-party applications.
Allowed value is a positive integer from 1 to x where xis the maximum size in characters of columns the driver will describe as SQL_VARCHAR.
Min Long Varchar Size
Specifies the minimum count of characters the driver reports for columns mapped as SQL_LONGVARCHAR. If the size of a SQL_LONGVARCHAR column is less than the value specified, the driver increases the reported size of the column to this value when calling SQLDescribeCol and SQLColumns. This allows you to fetch SQL_LONGVARCHAR columns whose size is smaller than the minimum imposed by some third-party applications, such as SQL Server Linked Server.
Allowed value is a positive integer from 1 to x where x is the minimum size in characters the driver reports for columns mapped to the SQL_LONGVARCHAR type.
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 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.
Optionally, click the Security tab to specify security data source settings.