DBPROP_ALTERCOLUMN |
Type: VT_I4 R/W: R Description: Alter Column Support Notes: This provider returns DBCOLUMNDESCFLAGS_DBCID and DBCOLUMNDESCFLAGS_PROPERTIES. The only properties that can be modified are DBPROP_COL_SEED, DBPROP_COL_INCREMENT, and DBPROP_COL_DEFAULT. DBPROP_COL_SEED and DBPROP_COL_INCREMENT can be set only on an identity column. |
DBPROP_COLUMNDEFINITION |
|
DBPROP_DBMSNAME |
|
DBPROP_DBMSVER |
Type: VT_BSTR R/W: R only Description: DBMS Version Notes: Specifies the version of the product accessed by the provider. For this provider, the string is "3.00.0000". |
DBPROP_DSOTHREADMODEL |
Type: VT_I4 R/W: R only Description: Data Source Object Threading Model Notes: Specifies the threading model of the data source object. For this provider, the value is DBPROPVAL_RT_SINGLETHREAD. |
DBPROP_IDENTIFIERCASE |
Type: VT_I4 R/W: R only Description: Identifier Case Sensitivity Notes: Specifies how identifiers respond to case. Because identifiers in SQL Server Compact are case-insensitive and are stored in mixed case in the system catalog, the value for this provider must be DBPROPVAL_IC_MIXED. |
DBPROP_MULTIPLESTORAGEOBJECTS |
Type: VT_BOOL R/W: R only Description: Multiple Storage Objects Notes: For this provider, the value is always VARIANT_FALSE. This indicates that the provider supports only one open storage object at a time. |
DBPROP_NULLCOLLATION |
Type: VT_I4 R/W: R only Description: NULL Collation Order Notes: For this provider, the value is always DBPROPVAL_NC_LOW. This indicates that null values are sorted at the low end of the list. |
DBPROP_OLEOBJECTS |
Type: VT_I4 R/W: R only Description: OLE Object Support Notes: Specifies a bitmask that indicates the ways in which the provider supports access to BLOBs and COM objects stored in columns. For this provider, the value is always DBPROPVAL_OO_BLOB. This indicates that the provider supports access to BLOBs as structured objects. The consumer determines what interfaces are supported through DBPROP_STRUCTUREDSTORAGE. |
DBPROP_OPENROWSETSUPPORT |
|
DBPROP_PERSISTENTIDTYPE |
|
DBPROP_PROVIDERFILENAME |
Type: VT_BSTR R/W: R only Description: Provider Name Notes: Specifies the file name of the provider. (Before Microsoft Data Access Components (MDAC) 2.5, this property is named DBPROP_PROVIDERNAME.) |
DBPROP_PROVIDEROLEDBVER |
|
DBPROP_PROVIDERVER |
|
DBPROP_STRUCTUREDSTORAGE |
Type: VT_I4 R/W: R only Description: Structured Storage Notes: Specifies a bitmask that indicates which interfaces on a storage object are supported by the rowset; that is, a combination of zero or more of DBPROPVAL_SS_ISEQUENTIALSTREAM or DBPROPVAL_SS_ILOCKBYTES. |
DBPROP_SUPPORTEDTXNDDL |
Type: VT_I4 R/W: R only Description: Transaction DDL Notes: Specifies whether Data Definition Language (DDL) statements are supported in transactions. For this provider, the value is always DBPROPVAL_TC_ALL. This indicates that transactions can contain DDL and Data Manipulation Language (DML) statements in any order. |
DBPROP_SUPPORTEDTXNISOLEVELS |
Type: VT_I4 R/W: R only Description: Isolation Levels Notes: This provider supports DBPROPVAL_TI_READCOMMITTED, DBPROPVAL_TI_REPEATABLEREAD, and DBPROPVAL_TI_SERIALIZABLE. |
DBPROP_SUPPORTEDTXNISORETAIN |
Type: VT_I4 R/W: R only Description: Isolation Retention Notes: This provider supports the following values: DBPROPVAL_TR_COMMIT_DC. This indicates that the transaction preserves its isolation across a retaining commit. DBPROPVAL_TR_ABORT_DC, which indicates that the transaction may either preserve or dispose of its isolation across a retaining abort. |