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 Driver for Redshift Setup dialog box

Connection Options: Advanced Description
Application Using Threads Determines whether the driver works with applications using multiple ODBC threads.

If enabled, the driver works with single-threaded and multi-threaded applications.

If disabled, the driver does not work with multi-threaded applications. If using the driver with single-threaded applications, this value avoids additional processing required for ODBC thread-safety standards.

Default: Enabled
Enable SQLDescribeParam Determines whether SQLDescribeParam returns the Datatype, ParameterSize, DecimalDigits, and Nullable information for parameters in a prepared statement.

If enabled, SQLDescribeParam returns the Datatype, ParameterSize, DecimalDigits, and Nullable information for parameters in a prepared statement.

If disabled, the driver does not support SQLDescribeParam and returns the message: Driver does not support this function.

Default: Enabled
Fetch TSWTZ as Timestamp Determines whether the driver returns column values with the timestamp with time zone data type as the ODBC data type SQL_TYPE_TIMESTAMP or SQL_VARCHAR.

If enabled, the driver returns column values with the timestamp with time zone data type as the ODBC type SQL_TYPE_TIMESTAMP. The time zone information in the fetched value is truncated. Use this value if your application needs to process values the same way as TIMESTAMP columns.

If disabled, the driver returns column values with the timestamp with time zone data type as the ODBC data type SQL_VARCHAR. Use this value if your application requires the time zone information in the fetched value.

Default: Disabled
TCP Keep Alive Specifies whether the driver enables TCPKeepAlive.

If disabled, the driver does not enable TCPKeepAlive.

If enabled, the driver enables TCPKeepAlive.

Default: Disabled
Show Selectable Tables

Determines whether the driver returns metadata for all tables or only those for which the user has Select privileges. It can help the users with restricted Select privileges retrieve metadata for the required tables.

If enabled, the driver returns metadata for all tables, irrespective of Select privileges.

If disabled, the driver returns metadata only for the tables for which the user has Select privileges.

Default: Enabled
Extended Column MetaData Determines how the driver returns column metadata when using SQLDescribeCol and SQLColAttribute. For more information, see "Extended Column MetaData."

Default: Disabled
Transaction Error Behavior Determines how the driver handles errors that occur within a transaction. When an error occurs in a transaction, the Redshift server does not allow any operations on the connection except for rolling back the transaction.

If set to 0 - Do Nothing, the driver does not roll back the transaction when an error occurs. The application must handle the error and roll back the transaction. Any operation on the statement other than a rollback results in an error.

If set to 1 - Rollback, the driver rolls back the transaction when an error occurs. In addition to the original error message, the driver posts an error message indicating that the transaction has been rolled back.

Default: 1 - Rollback
Initialization String A SQL command that is issued immediately after connecting to the database to manage session settings.

Default: None
Report Codepage Conversion Errors Specifies how the driver handles code page conversion errors that occur when a character cannot be converted from one character set to another.

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.

Default: 0 - Ignore Errors
Login Timeout The number of seconds the driver waits for a connection to be established before returning control to the application and generating a timeout error.

Default: 15
Query Timeout The number of seconds for the default query timeout for all statements that are created by a connection.

Default: 0
Max Char Size Specifies the maximum size of columns of type SQL_CHAR that the driver describes through result set descriptions and catalog functions.

Default: None
Max Varchar Size Specifies the maximum size of columns of type SQL_VARCHAR that the driver describes through result set descriptions and catalog functions.

Default: None

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 Customer Support. You can include any valid connection option in the Extended Options string, for example: 

Database=myredshift;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.

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.

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.
  • Failover tab allows you to specify failover data source settings.
  • Pooling tab allows you to specify connection pooling settings.
  • Authentication tab allows you to specify authentication settings.