Data Source Information Properties (OLE DB Jet Provider)
The DBPROPSET_DATASOURCEINFO property set contains the following properties. All of these properties are in the Data Source Information property group. These properties are read-only in the OLE DB Provider for Microsoft Jet and constitute a set of static information about the provider and data store.
Property ID |
Description |
---|---|
DBPROP_ACTIVESESSIONS |
Type: VT_I4 Typical R/W: R only Description: Active Sessions Specifies the maximum number of sessions that can exist at the same time. Jet can support a maximum of 128 sessions. |
DBPROP_ASYNCTXNABORT |
Type: VT_BOOL Typical R/W: R only Description: Asynchronous Abort Specifies whether asynchronous abortion of transactions is allowed. |
DBPROP_ASYNCTXNCOMMIT |
Type: VT_BOOL Typical R/W: R only Description: Asynchronous Commit Specifies whether asynchronous commitment of transactions is allowed. |
DBPROP_BYREFACCESSORS |
Type: VT_BOOL Typical R/W: R only Description: Pass By Ref Accessors Specifies whether the provider supports the DBACCESSOR_PASSBYREF flag in IAccessor::CreateAccessor. This applies both to row and to parameter accessors. |
DBPROP_CATALOGLOCATION |
Type: VT_I4 Typical R/W: R only Description: Catalog Location Specifies the position in a text command of a catalog name in a qualified table name, that is:
|
DBPROP_CATALOGTERM |
Type: VT_BSTR Typical R/W: R only Description: Catalog Term Specifies the name that the data store uses for a catalog; for example, "catalog", "database", or "directory". This is used to build user interfaces. |
DBPROP_COLUMNDEFINITION |
Type: VT_I4 Typical R/W: R only Description: Column Definition A bitmask defining the valid clauses for the definition of a column, that is:
|
DBPROP_CONCATNULLBEHAVIOR |
Type: VT_I4 Typical R/W: R only Description: Null Concatenation Behavior Specifies how the data store handles concatenation of null-valued and non-null-valued character data type columns, that is:
|
DBPROP_DATASOURCENAME |
Type: VT_BSTR Typical R/W: R only Description: Data Source Name The name of the data store. This can be used during the connection process. |
DBPROP_DATASOURCEREADONLY |
Type: VT_BOOL Typical R/W: R only Description: Read-Only Data Source This can be:
|
DBPROP_DBMSNAME |
Type: VT_BSTR Typical R/W: R only Description: DBMS Name Specifies the name of the product accessed by the provider. For this provider, the string is "MS Jet". |
DBPROP_DBMSVER |
Type: VT_BSTR Typical R/W: R only Description: DBMS Version Specifies the version of the product accessed by the provider. For this provider, the string is "4.00.0000". |
DBPROP_DSOTHREADMODEL |
Type: VT_I4 Typical R/W: R only Description: Data Source Object Threading Model Specifies the threading model of the data source object. For this provider, the value is DBPROPVAL_RT_FREETHREAD. |
DBPROP_GROUPBY |
Type: VT_I4 Typical R/W: R only Description: Group By Support Specifies the relationship between the columns in a GROUP BY clause and the non-aggregated columns on a select list. For this provider, the value is DBPROPVAL_GB_CONTAINS_SELECT, which indicates that the GROUP BY clause must contain all non-aggregated columns in the select list. It can also contain columns that are not on the select list. |
DBPROP_HETEROGENEOUSTABLES |
Type: VT_I4 Typical R/W: R only Description: Heterogeneous Table Support Specifies a bitmask that indicates whether the provider can join tables from different catalogs or providers. For this provider, the value is:
|
DBPROP_IDENTIFIERCASE |
Type: VT_I4 Typical R/W: R only Description: Identifier Case Sensitivity Specifies how identifiers respond to case. For this provider, the value is DBPROPVAL_IC_MIXED, which indicates that identifiers in SQL are case-insensitive and are stored in mixed case in the system catalog. |
DBPROP_MAXINDEXSIZE |
Type: VT_I4 Typical R/W: R only Description: Maximum Index Size Specifies the maximum number of bytes allowed in the combined columns of an index. If there is no limit specified or if the limit is unknown, this value defaults to zero. For this provider, the value is 255. |
DBPROP_MAXROWSIZE |
Type: VT_I4 Typical R/W: R only Description: Maximum Row Size Specifies the maximum length of a single row in a table. If there is no specified limit or the limit is unknown, this value is zero. |
DBPROP_MAXROWSIZEINCLUDESBLOB |
Type: VT_BOOL Typical R/W: R only Description: Maximum Row Size Includes BLOB
|
DBPROP_MAXTABLESINSELECT |
Type: VT_I4 Typical R/W: R only Description: Maximum Tables in SELECT Specifies the maximum number of tables allowed in the FROM clause of a SELECT statement. If there is no specified limit or the limit is unknown, this value is zero. For this provider, the value is always zero. |
DBPROP_MULTIPLEPARAMSETS |
Type: VT_BOOL Typical R/W: R only Description: Multiple Parameter Sets For this provider, the value is always VARIANT_TRUE, which indicates that the provider supports multiple parameter sets but not multiple result sets. |
DBPROP_MULTIPLERESULTS |
Type: VT_I4 Typical R/W: R only Description: Multiple Results If multiple results objects are not supported, DBPROPVAL_MR_NOTSUPPORTED is returned. |
DBPROP_MULTIPLESTORAGEOBJECTS |
Type: VT_BOOL Typical R/W: R only Description: Multiple Storage Objects For this provider, the value is always VARIANT_FALSE, which indicates that the provider supports only one open storage object at a time. Any method that attempts to open a second storage object returns a status of DBSTATUS_E_CANTCREATE for the column on which it attempted to open the second storage object, regardless of the rows or columns in which the objects are constructed. This applies to provider-owned storage objects retrieved from GetData. |
DBPROP_MULTITABLEUPDATE |
Type: VT_BOOL Typical R/W: R only Description: Multiple Table Update For this provider, the value is always VARIANT_TRUE, which indicates that the provider can update rowsets derived from multiple tables. |
DBPROP_NULLCOLLATION |
Type: VT_I4 Typical R/W: R only Description: NULL Collation Order For this provider, the value is always DBPROPVAL_NC_LOW, which indicates that null values are sorted at the low end of the list. |
DBPROP_OLEOBJECTS |
Type: VT_I4 Typical R/W: R only Description: OLE Object Support 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, which indicates that the provider supports access to BLOBs as structured objects. The consumer determines what interfaces are supported through DBPROP_STRUCTUREDSTORAGE. |
DBPROP_ORDERBYCOLUMNSINSELECT |
Type: VT_I4 Typical R/W: R only Description: Order By Columns in Select List For this provider, the value is always VARIANT_FALSE, which indicates that columns in an ORDER BY clause are not required to be on the select list. |
DBPROP_OUTPUTPARAMETERAVAILABILITY |
Type: VT_I4 Typical R/W: R only Description: Output Parameter Availability For this provider, the value is always DBPROPVAL_OA_NOTSUPPORTED, which indicates that output parameters are not supported. |
DBPROP_PERSISTENTIDTYPE |
Type: VT_I4 Typical R/W: R only Description: Persistent ID Type Specifies an integer that indicates the type of DBID that the provider uses when persisting DBIDs for tables, indexes, and columns. This is usually the type of DBID that the provider considers the most permanent under schema changes and physical data reorganizations. For this provider, the value is always DBPROPVAL_PT_NAME. |
DBPROP_PREPAREABORTBEHAVIOR |
Type: VT_I4 Typical R/W: R only Description: Prepare Abort Behavior Specifies how aborting a transaction affects prepared commands. For this provider, the value is always DBPROPVAL_CB_DELETE, which indicates that aborting a transaction deletes prepared commands. The application must re-prepare commands before executing them. |
DBPROP_PROCEDURETERM |
Type: VT_BSTR Typical R/W: R only Description: Procedure Term Specifies a character string with the data store vendor's name for a procedure; for example, "database procedure", "stored procedure", or "procedure". This is used to build user interfaces. |
DBPROP_PROVIDERFILENAME |
Type: VT_BSTR Typical R/W: R only Description: Provider Name Specifies the file name of the provider. (Prior to MDAC 2.5, this property was named DBPROP_PROVIDERNAME.) |
DBPROP_PROVIDEROLEDBVER |
Type: VT_BSTR Typical R/W: R only Description: OLE DB Version Returns the version of OLE DB supported by the provider. The version is returned in the format ##.## ####, where the first two digits are the major version, the next two digits are the minor version, and the last four digits are the release version. |
DBPROP_QUOTEDIDENTIFIERCASE |
Type: VT_I4 Typical R/W: R only Description: Quoted Identifier Sensitivity Specifies how quoted identifiers treat case, that is:
|
DBPROP_ROWSETCONVERSIONCOMMAND |
Type: VT_BOOL Typical R/W: R only Description: Rowset Conversions On Command For this provider, the value is always VARIANT_TRUE, which indicates that callers to IConvertType::CanConvert can inquire on a command about conversions supported on rowsets generated by the command. |
DBPROP_SQLSUPPORT |
Type: VT_I4 Typical R/W: R only Description: SQL Support Specifies a bitmask that indicates the level of support for SQL. For this provider, the value is always DBPROPVAL_SQL_SUBMINIMUM. |
DBPROP_STRUCTUREDSTORAGE |
Type: VT_I4 Typical R/W: R only Description: Structured Storage Specifies a bitmask that indicates which interfaces on a storage object are supported by the rowset; that is, zero or more of:
|
DBPROP_SUBQUERIES |
Type: VT_I4 Typical R/W: R only Description: Subquery Support Specifies a bitmask that indicates the predicates in text commands that support subqueries; that is, zero or more of:
The DBPROPVAL_SQ_CORRELATED SUBQUERIES bit indicates that all predicates that support subqueries support correlated subqueries. |
DBPROP_SUPPORTEDTXNDDL |
Type: VT_I4 Typical R/W: R only Description: Transaction DDL Specifies whether Data Definition Language (DDL) statements are supported in transactions. For this provider, the value is always DBPROPVAL_TC_ALL, which indicates that transactions can contain DDL and DML statements in any order. |
DBPROP_SUPPORTEDTXNISOLEVELS |
Type: VT_I4 Typical R/W: R only Description: Isolation Levels Specifies a bitmask that indicates the supported transaction isolation levels; that is, zero or more of:
|
DBPROP_SUPPORTEDTXNISORETAIN |
Type: VT_I4 Typical R/W: R only Description: Isolation Retention Specifies a bitmask that indicates the supported transaction isolation retention levels; that is, zero or more of:
|
DBPROP_TABLETERM |
Type: VT_BSTR Typical R/W: R only Description: Table Term Specifies the name the data store uses for a table. |