MDAC 2.5 SDK - OLE DB Providers
OLE DB Provider for Microsoft Jet

Data Source Information Properties

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: DBPROPVAL_CL_START, which indicates the catalog name, is at the start of the fully qualified table name. DBPROPVAL_CL_END—The catalog name is at the end of the fully qualified name.
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: DBRPOPVAL_CD_NOTNULL, which indicates that columns can be created non-nullable.
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: DBPROPVAL_CB_NON_NULL, which indicates that the result is the concatenation of the non-null-valued column or columns.
DBRPOP_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: VARIANT_TRUE, which indicates that the data store is read-only. VARIANT_FALSE, which indicates that the data store is updatable.
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 nonaggregated 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 nonaggregated 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: DBPROPVAL_HT_DIFFERENT_CATALOGS DBPROPVAL_HT_DIFFERENT_PROVIDERS
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 For this provider, the value is always VARIANT_FALSE, which indicates that the maximum row size returned for the DBPROP_MAXROWSIZE property does not include the length of all BLOB data.
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 reprepare 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: DBPROPVAL_IC_MIXED, which indicates that identifiers quoted in SQL are case-insensitive and are stored in mixed case in the system catalog.
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: DBPROPVAL_SS_ISEQUENTIALSTREAM DBPROPVAL_SS_ILOCKBYTES
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: DBPROPVAL_SQ_CORRELATED SUBQUERIES DBPROPVAL_SQ_COMPARISON DBPROPVAL_SQ_EXISTS DBPROPVAL_SQ_IN DBPROPVAL_SQ_QUANTIFIED 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: DBPROPVAL_TI_CHAOS DBPROPVAL_TI_READUNCOMMITTED DBPROPVAL_TI_BROWSE DBPROPVAL_TI_CURSORSTABILITY DBPROPVAL_TI_READCOMMITTED
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: DBPROPVAL_TR_COMMIT_DC, which 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.
DBPROP_TABLETERM	Type: VT_BSTR Typical R/W: R only Description: Table Term Specifies the name the data store uses for a table.