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.