Attribute

CatalogMode (CM)

Purpose

Specifies whether the driver uses native catalog functions to retrieve information returned by the SQLTables, SQLColumns, and SQLStatistics catalog functions.

Valid Values

0 | 1 | 2

Behavior

If set to 0 (Mixed), the driver uses a combination of ODBC catalog functions and driver-discovered information to retrieve catalog information. Select this option for the optimal balance of performance and accuracy.
Note: In this setting, the driver uses the best techniques for retrieving information. These techniques vary depending on the server used, which may result in differences in performance.

If set to 1 (Native), the driver uses native catalog functions to retrieve information returned by the SQLTables, SQLColumns, and SQLStatistics catalog functions. This setting provides the best performance, but at the expense of less-accurate catalog information.

If set to 2 (Query Based), the driver uses driver-discovered information to retrieve catalog information. This option provides highly accurate catalog information, but at the expense of slower performance.

Default

0 (Mixed)

GUI Tab

Advanced tab

See Also