|
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_EXISTS
VALUE=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.
|