DBPROP_SQLSUPPORT

Property group: Data Source Information

Property set: DBPROPSET_DATASOURCEINFO

Type: VT_I4

Typical R/W: R

Description: SQL Support

A bitmask specifying the level of support for SQL. A combination of zero or more of the following:

  • DBPROPVAL_SQL_NONE ? SQL is not supported.

  • DBPROPVAL_SQL_ODBC_MINIMUM

  • DBPROPVAL_SQL_ODBC_CORE

  • DBPROPVAL_SQL_ODBC_EXTENDED ? These levels correspond to the levels of SQL conformance defined in ODBC version 2.5. These levels are cumulative. That is, if the provider supports one level, it also sets the bits for all lower levels. For example, if the provider sets the DBPROPVAL_SQL_ODBC_CORE bit, it also sets the DBPROPVAL_SQL_ODBC_MINIMUM bit.

  • DBPROPVAL_SQL_ESCAPECLAUSES ? The provider supports the ODBC escape clause syntax.

  • DBPROPVAL_SQL_ANSI92_ENTRY

  • DBPROPVAL_SQL_FIPS_TRANSITIONAL

  • DBPROPVAL_SQL_ANSI92_INTERMEDIATE

  • DBPROPVAL_SQL_ANSI92_FULL ? These levels correspond to the levels in ANSI SQL-92. These levels are cumulative. That is, if the provider supports one level, it also sets the bits for all lower levels.

  • DBPROPVAL_SQL_ANSI89_IEF ? The provider supports the ANSI89 Integrity Enhancement Facility.

  • DBPROPVAL_SQL_SUBMINIMUM ? The provider supports the DBGUID_SQL dialect and parses the command text according to SQL rules but does not support either the minimum ODBC level or the ANSI SQL-92 Entry level. This level is not cumulative; providers that support at least the minimal ODBC Level or ANSI SQL-92 Entry Level do not set this bit. OLE DB consumers can determine whether or not the provider supports the DBGUID_SQL dialect by verifying that the DBPROPVAL_SQL_NONE bit is not set.

Show: