Data Source Information Properties (OLE DB)

The DBPROPSET_DATASOURCEINFO property set contains the following properties. All these properties are in the Data Source Information property group. These properties are read-only in the OLE DB provider for SQL Server 2005 Compact Edition (SQL Server Compact Edition) and make up a set of static information about the provider and data store.

Property ID	Description
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	Type: VT_I4 R/W: R Description: Column Definition Notes: For this provider, the value is always DBPROPVAL_CD_NOTNULL.
DBPROP_DBMSNAME	Type: VT_BSTR R/W: R only Description: DBMS Name Notes: Specifies the name of the product accessed by the provider. For this provider, the string is "SQL Server for Windows CE".
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 Edition 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	Type: VT_I4 R/W: R Description: Open Rowset Support Notes: This provider supports the values DBPROPVAL_ORS_TABLE and DBPROPVAL_ORS_INTEGRATEDINDEX.
DBPROP_PERSISTENTIDTYPE	Type: VT_I4 R/W: R Description: Persistent ID Type Notes: For this provider, the value is DBPROPVAL_PT_NAME.
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	Type: VT_BSTR R/W: R only Description: OLE DB Version Notes: This provider returns 02.50.00.
DBPROP_PROVIDERVER	Type: VT_BSTR R/W: R Description: Provider Version Notes: For this provider, the version returned is 03.00.0000.
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.