SQL Support Property
The SQL Support property returns a bitmask specifying the level of support for SQL.
Applies To
| Connection Object |
Syntax
object.Properties("SQL Support")
Parts
object
Expression that evaluates to an object in the Applies To list.
Returns
Zero or more of the following settings:
| Constant | Description |
|---|---|
| DBPROPVAL_SQL_NONE | SQL is not supported. |
| DBPROPVAL_SQL_ODBC_MINIMUM | The provider supports the minimum capabilities ODBC by setting the DBPROPVAL_SQL_ODBC_MINIMUM bit. |
| DBPROPVAL_SQL_ODBC_CORE | The provider supports the core capabilities ODBC by setting the DBPROPVAL_SQL_ODBC_CORE bit. |
| 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 | The provider supports the entry level of SQL 92. |
| DBPROPVAL_SQL_FIPS_TRANSITIONAL | The provider supports the transitional level of the FIPS 127-2 standard. |
| DBPROPVAL_SQL_ANSI92_INTERMEDIATE | The provider supports the intermediate level of SQL 92. |
| 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. |
Data Type
adInteger
Modifiable
Read-only
OLE DB Property
DBPROP_SQLSUPPORT