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.