Configuring Advanced Options

You can configure advanced options to modify the behavior of the driver.

To configure advanced options:

  1. To access advanced options, open the ODBC Data Source Administrator where you created the DSN, then select the DSN, then click Configure, and then click Advanced Options.
  2. To retrieve data using double-buffering instead of single-buffering, select the Enable Double-Buffering check box. You can configure the size of the buffer using the Rows Fetched Per Block setting.
  3. In the Rows Fetched Per Block field, type the number of database rows to be fetched per block.
  4. Choose one:
    • To return SQL_WVARCHAR for VARCHAR columns, and SQL_WCHAR for CHAR columns, select the Unicode SQL character types check box.
    • Or, to return SQL_VARCHAR for VARCHAR columns and SQL_CHAR for CHAR columns, clear the Unicode SQL character types check box.
  5. To enable support for hint syntax in SELECT statements, select the Check Select Statement Hint Syntax check box.
  6. In the Connection Sync Interval field, type the length, in seconds, for the interval between connection kee-alive requests.
  7. In the Binary/Character Length field, type the default buffer size for Character or Binary parameters.
  8. In the Decimal Precision field, type the default total number of digits for parameterized decimal values.
  9. In the Decimal Scale field, type the default number of digits behind the decimal point for parameterized decimal values.
  10. In the Array Column Length field, type the column length that the driver reports for array columns.
  11. To save your settings and close the Advanced Options dialog box, click OK.

Related topics