Export (0) Print
Expand All

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 Compact 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 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.

Show:
© 2014 Microsoft