skip to main content
Using the Driver : Configuring and Connecting to Data Sources : Data Source Configuration through a GUI : Advanced Tab
  

Try DataDirect Drivers Now
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.
Figure 2. Advanced tab
The Advanced Tab of the ODBC Driver for Apache Spark Setup dialog box
Connection Options: Advanced
Description
Default
If enabled, the SQLDescribeParam function describes parameters as a data type of SQL_VARCHAR with a length of 999 for statements.
If disabled, the SQLDescribeParam function returns the standard ODBC error IM001.
Disabled
If set enabled, results of catalog function calls are restricted to the tables and views in the current schema.
If disabled, results of catalog function calls are not restricted.
Disabled
If enabled the driver removes 3-part column qualifiers and replaces them with alias.column qualifiers. Column qualifiers are Microsoft Access compatible in this setting.
If disabled, the driver does not modify the request.
Disabled
If disabled, the driver does not enable TCPKeepAlive.
If enabled, the driver enables TCPKeepAlive.
Disabled
The number of cells the driver retrieves from a server for a fetch.
20000
The number of seconds the driver waits for a connection to be established before returning control to the application and generating a timeout error.
30
Specifies the maximum size of columns of the String data type that the driver describes through result set descriptions and catalog functions.
2147483647
If set to -10 - SQL_WLONGVARCHAR, all strings are described as SQL_WLONGVARCHAR
If set to -9 - SQL_WVARCHAR, all string columns are described as SQL_WVARCHAR.
-9 - SQL_WVARCHAR
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 0 - No Transactions, the data source and the driver do not support transactions. Metadata indicates that the driver does not support transactions.
0 - No Transactions
The maximum length of data (in KB) the driver can fetch from long columns in a single round trip and the maximum length of data that the driver can send using the SQL_DATA_AT_EXEC parameter.
The value must be in multiples of 1024 (for example, 1024, 2048).
1024
Specifies the threshold at which the driver describes columns of the data type VARCHAR as LONGVARCHAR. If the size of the VARCHAR column exceeds the value specified, the driver will describe the column as LONGVARCHAR when calling SQLDescribeCol and SQLColumns. This option allows you to fetch columns that would otherwise exceed the upper limit of the VARCHAR type for some third-party applications, such as SQL Server Linked Server.
None. If no value is specified, the driver will not change the column size reported for SQL_LONGVARCHAR columns.
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 will increase 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.
None. If no value is specified, the driver will not change the column size reported for SQL_LONGVARCHAR columns.
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 include any valid connection option in the Extended Options string, for example:
Database=mysparksqldb;UndocumentedOption1=value[;UndocumentedOption2=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.
If you finished configuring your driver, proceed to Step 6 in Data Source Configuration through a GUI. Optionally, you can further configure your driver by clicking on the following tabs. The following sections provide details on the fields specific to each configuration tab:
*General tab allows you to configure options that are required for creating a data source.
*Security tab allows you to specify security data source settings.