skip to main content
Configuring Hybrid Data Pipeline Driver for ODBC : Connecting applications to the connectivity service : Connection Properties : Optional Connection Properties : Advanced Tab Options
  

Try Now
Advanced Tab Options
The Advanced tab contains the following fields:
Advanced tab
The following table describes fields in the Advanced tab of the Progress DataDirect Hybrid Data Pipeline ODBC 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.
Table 130. Advanced Tab Options
Field Name (Short name)
Description
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 .
Enabled
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 .
0
Query Timeout
QueryTimeout (QT
The number of seconds before timeout for all statements that are created by a connection. A value of 0 prevents a query from timing out. For more information, see Query Timeout .
0
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:
*If set to 0 - Ignore Errors, the driver substitutes 0x1A for each character that cannot be converted and does not return a warning or error
*If set to 1 - Return Error, the driver returns an error instead of substituting 0x1A for unconverted characters.
*If set to 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 0 - No Transactions, the data source and the driver do not support transactions. Metadata indicates that the driver does not support transactions.
If set to 1 - Ignore, the data source does not support transactions and the driver always operates in auto-commit mode. Calls to set the driver to manual commit mode and to commit transactions are ignored. Calls to rollback a transaction cause the driver to return an error indicating that no transaction is started. Metadata indicates that the driver supports transactions and the ReadUncommitted transaction isolation level.
If set to 2 - Transactions, the data source and driver support manual transactions for supported data stores. Support for isolation levels depends on which backend data store is being used. If the data store does not support transactions (for example, Salesforce), then Transaction Mode is switched to 0 - No Transactions.
See also Transaction Mode .
2 - 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:
America/New_York,-05:00D
or
America/New_York,-5D
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.
Enabled
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.
1024
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.
empty
Varchar Threshold
VarcharThreshold (VT)
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.
empty
Min Long Varchar Size
MinLongVarcharSize (MINLVS)
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.
empty
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.