Data Source Information Property Group
- Last Updated: May 12, 2026
- 4 minute read
- OpenAccess SDK
- Version 8.1
- Documentation
The following table lists the properties in the DBPROPSET_DATASOURCEINFO property set supported by the ADO Client. These properties are in the Data Source Information property group, are read-only properties, and constitute a set of static information about the data provider and data source. For more information about these properties, refer to your Microsoft OLE DB programming documentation.
Note: Some values are database-specific and depend on the OpenAccess SDK service you are using. These database-specific values are not listed in the table.
OLE DB Data Source Information Properties Supported by the ADO Client
| Property ID | Default Value and Description |
| DBPROP_ACTIVESESSIONS | VALUE=0. There is no limit to the number of sessions that can exist at one time. |
| DBPROP_ASYNCTXNABORT | VALUE=VARIANT_FALSE. The ADO Client cannot abort transactions asynchronously. |
| DBPROP_ASYNCTXNCOMMIT | VALUE=VARIANT_FALSE. The ADO Client cannot commit transactions asynchronously. |
| DBPROP_BYREFACCESSORS | VALUE=VARIANT_FALSE. The ADO Client does not support the DBACCESSOR_PASSBYREF flag. |
| DBPROP_CATALOGLOCATION | The value depends on the OpenAccess SDK service you are using. |
| DBPROP_CATALOGTERM | Specifies the name the data source uses for a catalog. VALUE="Database" |
| DBPROP_CATALOGUSAGE | A combination of zero or one or more of the following: VALUE=DBPROPVAL_CU_DML_STATEMENTS. Catalog names are supported in all Data Manipulation Language (DML) statements. VALUE=DBPROPVAL_CU_TABLE_DEFINITION. Catalog names are supported in all table definition statements. VALUE=DBPROPVAL_CU_INDEX_DEFINITION. Catalog names are supported in all index definition statements. VALUE=DBPROPVAL_CU_PRIVILEGE_DEFINITION. Catalog names are supported in all privilege definition statements. |
| DBPROP_COLUMNDEFINITION | VALUE=DBPROPVAL_CD_NOTNULL. Columns can be created non-nullable. |
| DBPROP_CONCATNULLBEHAVIOR | The value depends on the OpenAccess SDK service you are using. |
| DBPROP_CONNECTIONSTATUS | VALUE=DBPROPVAL_CS_INITIALIZED. The data source is in an initialized state and able to communicate with the data store. |
| DBPROP_DATASOURCENAME | Specifies the name of the data source used during connection. The data source is defined using the Configuration Manager. See Using the ADO Client for more information about configuring ADO data sources. |
| DBPROP_DATASOURCEREADONLY | VALUE=VARIANT_FALSE. The data source can be updated. |
| DBPROP_DBMSNAME | Specifies the name of the data store accessed by the ADO Client. The value depends on the OpenAccess SDK service you are using. |
| DBPROP_DBMSVER | Specifies the version of the DBMS that data provider is currently accessing. This value depends on the OpenAccess SDK service you are using. |
| DBPROP_DSOTHREADMODEL | VALUE=DBPROP_RT_FREETHREAD. The ADO Client supports the free-threading model. |
| DPROP_GROUPBY | This value depends on the OpenAccess SDK service you are using. |
| DBPROP_HETEROGENEOUSTABLES | VALUE=0. Heterogeneous joins are not supported. |
| DBPROP_IDENTIFIERCASE | This value depends on the OpenAccess service you are using. |
| DBPROP_MAXINDEXSIZE | This value depends on the OpenAccess service you are using. |
| DBPROP_MAXROWSIZE | VALUE=0. There is no limit on the maximum length of a single row in a table. |
| DBPROP_MAXROWSIZEINCLUDESBLOB | VALUE=VARIANT_FALSE. The maximum row size does not include the length of all BLOB data. |
| DBPROP_MAXTABLEINSELECT | VALUE=0. There is no limit on the number of tables allowed in the FROM clause of a Select statement. |
| DBPROP_MULTIPLEPARAMSETS | VALUE=VARIANT_TRUE. The ADO Client supports multiple parameter sets at the same time. |
| DBPROP_MULTIPLERESULTS | VALUE=DBPROPVAL_MR_SUPPORTED. The ADO Client supports multiple results objects. |
| DBPROP_MULTIPLESTORAGEOBJECTS | VALUE=VARIANT_TRUE. The ADO Client supports more than one open storage object at a time. |
| DBPROP_MULTITABLEUPDATE | VALUE=VARIANT_FALSE. The ADO Client cannot update rowsets derived from multiple tables. |
| DBPROP_NULLCOLLATION | The value depends on the OpenAccess SDK service you are using. |
| DBPROP_OLEOBJECTS | VALUE=DBPROPVAL_OO_BLOB. The ADO Client supports access to BLOBs as structured storage objects. |
| DBPROP_OPENROWSETSUPPORT | VALUE=DBPROPVAL_ORS_TABLE. The ADO Client supports opening tables through IOpenRowset. |
| DBPROP_ORDERBYCOLUMNSINSELECT | This value depends on the OpenAccess SDK service you are using. |
| DBPROP_OUTPUTPARAMETERAVAILABILITY | VALUE=DBPROPVAL_OA_ATROWRELEASE. If a command returns a single result that is a rowset, output parameter data is available at the time the rowset is completely released. |
| DBPROP_PERSISTENTIDTYPE | VALUE=DBPROPVAL_PT_NAME. The data provider uses this type of DBID when storing (persisting) DBIDs for tables and columns. |
| DBPROP_PREPAREABORTBEHAVIOR | The value depends on the OpenAccess SDK service you are using. |
| DBPROP_PREPARECOMMITBEHAVIOR | The value depends on the OpenAccess SDK service you are using. |
| DBPROP_PROCEDURETERM | This value depends on the OpenAccess SDK service you are using. |
| DBPROP_PROVIDERFRIENDLYNAME | Specifies the name of data provider, for example, OpenAccess SDK for ADO Provider. |
| DBPROP_PROVIDERNAME | VALUE=inoasnn.dll is the default, where nn is the release level of data provider. |
| DBPROP_PROVIDEROLEDBVER | Refer to the README file for the supported version of OLE DB supported by the ADO Client. |
| DBPROP_PROVIDERVER | Refer to the README file for the supported version. |
| DBPROP_QUOTEDIDENTIFIERCASE | This value depends on the OpenAccess SDK service you are using. |
| DBPROP_ ROWSETCONVERSIONSONCOMMAND | VALUE=VARIANT_TRUE. Callers can inquire on a command about conversions supported on rowsets generated by the command. |
| DBPROP_SCHEMATERM | This value depends on the OpenAccess SDK service you are using. |
| DBPROP_SCHEMAUSAGE | The value depends on the OpenAccess SDK service you are using. |
| DBPROP_SERVERNAME | Specifies the name of the server. |
| DBPROP_SQLSUPPORT | This value depends on the OpenAccess SDK service you are using. |
| DBPROP_STRUCTUREDSTORAGE | VALUE=DBPROPVAL_SS_ISEQUENTIALSTREAM. |
| DBPROP_ SUBQUERIES | A combination of zero, one, or more of the following: VALUE=DBPROPVAL_SQ_COMPARISON VALUE=DBPROPVAL_SQ_CORRELATEDSUBQUERIES. This indicates that all predicates that support subqueries support correlated subqueries. VALUE=DBPROPVAL_SQ_EXISTSVALUE=DBPROPVAL_SQ_IN VALUE=DBPROPVAL_SQ_QUANTIFIED |
| DBPROP_ SUPPORTEDTXNDDL | This value depends on the OpenAccess SDK service you are using. |
| DBPROP_ SUPPORTEDTXNISOLEVELS | This value depends on the OpenAccess SDK service you are using. |
| DBPROP_ SUPPORTEDTXNISORETAIN | VALUE=0. The data provider supports no transaction isolation retention levels. |
| DBPROP_TABLETERM | Specifies the name the data source uses for a table. VALUE=”Table” |
| DBPROP_USERNAME | Specifies a character string with the name used in a particular database. This can be different from the login name. |