Supported OLE DB Properties of the Remoting Provider

Article
05/03/2017

Important

This feature will be removed in a future version of Windows. Avoid using this feature in new development work, and plan to modify applications that currently use this feature. Applications should instead use WCF Data Service.

Property	Description
DBPROP_ADC_BATCHSIZE	Property Set: DBPROPSET_ADC Default value: 15 Typical R/W: R Cursor Service?specific property that controls the number of rows that can be batched together when the rowset is being updated by the Cursor Service.
DBPROP_ADC_UPDATECRITERIA	Property Set: DBPROPSET_ADC Default value: 2 Typical R/W: R/W Cursor Service?specific property that specifies the update criteria (primary keys, timestamps, modified columns, and so on) to be used for the OCC-style batch updating by the Cursor Service when updating the recordset.
DBPROP_ASYNCHFETCHSIZE	Property Set: DBPROPSET_ADC Default value: 15 Typical R/W: R/W Cursor Service?specific property used by the consumers of remoted recordsets for asynchronous operations.
DBPROP_ASYNCHPREFETCHSIZE	Property Set: DBPROPSET_ADC Default value: 50 Typical R/W: R/W Cursor Service?specific property used by the consumers of remoted recordsets for asynchronous operations.
DBPROP_ASYNCHTHREADPRIORITY	Property Set: DBPROPSET_ADC Default value: 3 Typical R/W: R/W Cursor Service?specific property used by the consumers of remoted recordsets for asynchronous operations.
DBPROP_AUTH_CACHE_AUTHINFO	Property Set: DBPROPSET_DBINIT Default value: VARIANT_TRUE Typical R/W: R Standard OLE DB property. Specifies whether or not the data source object or enumerator is allowed to cache sensitive authentication information.
DBPROP_AUTH_ENCRYPT_PASSWORD	Property Set: DBPROPSET_DBINIT Default value: VARIANT_FALSE Typical R/W: R Standard OLE DB property. Specifies whether or not the consumer requires an encrypted password.
DBPROP_AUTH_INTEGRATED	Property Set: DBPROPSET_DBINIT Default value: NULL Typical R/W: R Standard OLE DB property. A string containing the name of the authentication server to identify the user.
DBPROP_AUTH_MASK_PASSWORD	Property Set: DBPROPSET_DBINIT Default value: VARIANT_FALSE Typical R/W: R Standard OLE DB property. Specifies whether or not the consumer requires a masking of the sent password.
DBPROP_AUTH_PASSWORD	Property Set: DBPROPSET_DBINIT Default value: VT_EMPTY Typical R/W: R Standard OLE DB property specifying the string containing the password to be used in connecting.
DBPROP_AUTH_PERSIST_ENCRYPTED	Property Set: DBPROPSET_DBINIT Default value: VARIANT_FALSE Typical R/W: R Standard OLE DB property. Specifies whether or not the consumer requires the data source object to persist encrypted authentication information.
DBPROP_AUTH_PERSIST_SENSITIVE_AUTHINFO	Property Set: DBPROPSET_DBINIT Default value: VARIANT_TRUE Typical R/W: R Standard OLE DB property. Specifies whether or not the consumer should persist sensitive authentication information.
DBPROP_AUTH_USERID	Property Set: DBPROPSET_DBINIT Default value: VT_EMPTY Typical R/W: R Standard OLE DB property containing the user ID.
DBPROP_COMMANDTIMEOUT	Property Set: DBPROPSET_ROWSET Default value: n/a Typical R/W: R/W Standard OLE DB property that specifies the time after which the command should time out.
DBPROP_DSOTHREADMODEL	Property Set: DBPROPSET_DATASOURCEINFO Default value: DBPROPVAL_RT_FREETHREAD Typical R/W: R Standard OLE DB property. This bitmask specifies the data source object?supported threading models.
DBPROP_INIT_DATASOURCE	Property Set: DBPROPSET_DBINIT Default value: VT_EMPTY Typical R/W: R Standard OLE DB property with the name of the connection data store or enumerator.
DBPROP_INIT_HWND	Property Set: DBPROPSET_DBINIT Default value: 0 Typical R/W: R Standard OLE DB property that specifies the window handle to be used.
DBPROP_INIT_IMPERSONATION_LEVEL	Property Set: DBPROPSET_DBINIT Default value: DB_IMP_LEVEL_DELEGATE Typical R/W: R Standard OLE DB property that holds the impersonation level.
DBPROP_INIT_LCID	Property Set: DBPROPSET_DBINIT Default value: VT_EMPTY Typical R/W: R/W Standard OLE DB property specifying the locale of preference for the consumer.
DBPROP_INIT_LOCATION	Property Set: DBPROPSET_DBINIT Default value: VT_EMPTY Typical R/W: R/W Standard OLE DB property that holds the location of the data source object or enumerator.
DBPROP_INIT_MODE	Property Set: DBPROPSET_DBINIT Default value: DB_MODE_READWRITE \| DB_MODE_SHARE_DENY_NONE Typical R/W: R/W Standard OLE DB property. A bitmask specifying access permissions.
DBPROP_INIT_PROMPT	Property Set: DBPROPSET_DBINIT Default value: DBPROPMT_NOPROMPT Typical R/W: R Standard OLE DB property that specifies whether or not to prompt the user during initialization.
DBPROP_INIT_PROTECTION_LEVEL	Property Set: DBPROPSET_DBINIT Default value: DB_PROT_LEVEL_NONE Typical R/W: R Standard OLE DB property that specifies the level of network connection protection of sent data.
DBPROP_INIT_PROVIDERSTRING	Property Set: DBPROPSET_DBINIT Default value: VT_EMPTY Typical R/W: R/W Standard OLE DB property that specifies provider-specific, extended connection information.
DBPROP_INIT_TIMEOUT	Property Set: DBPROPSET_DBINIT Default value: VT_EMPTY Typical R/W: R/W Standard OLE DB property that specifies the number of seconds to wait for initialization to complete.
DBPROP_IRowsetChange	Property Set: DBPROPSET_ROWSET Default value: n/a Typical R/W: R/W with exceptions Standard OLE DB property that specifies whether or not the rowset supports this interface. Specifically, it controls whether the remoted recordset should be updatable.
DBPROP_IRowsetUpdate	Property Set: DBPROPSET_ROWSET Default value: n/a Typical R/W: R/W with exceptions Standard OLE DB property that specifies whether or not the rowset supports this interface. Specifically, it controls whether the remoted recordset should be batch-updatable.
DBPROP_MAXROWS	Property Set: DBPROPSET_ROWSET Default value: n/a Typical R/W: R/W Standard OLE DB property that specifies the maximum number of rows that can be returned in a rowset.
DBPROP_MSREMOTE_CURRENT_DFMODE	Property Set: DBPROPSET_MSREMOTE_DATASOURCE Type: VT_I4 Default value: 21 Typical R/W: R/W Remoting Provider property that specifies which version of the DataFactory object has last been accessed.
DBPROP_MSREMOTE_DFMODE	Property Set: DBPROPSET_MSREMOTE_DBINIT Type: VT_BSTR Default value: VT_EMPTY Typical R/W: R/W Remoting Provider property that, in order to use the appropriate methods, specifies which version of the DataFactory object is expected to be encountered. Example: DFMode=21,20
DBPROP_MSREMOTE_HANDLER	Property Set: DBPROPSET_MSREMOTE_DBINIT Type: VT_BSTR Default value: VT_EMPTY Typical R/W: R/W Remoting Provider property that specifies the ADO Event Handler and its arguments. Example: Handler=,,MSDFMAP.Handler,arg1,arg2,... For more information about the ADO Event Handler, see "ADO Event Handler Summary" in the ADO Programmer's Reference.
DBPROP_MSREMOTE_PROVIDER	Property Set: DBPROPSET_MSREMOTE_DBINIT Type: VT_BSTR Default value: VT_EMPTY Typical R/W: R/W Remoting Provider property that specifies the name of the Remoting Provider to use.
DBPROP_MSREMOTE_SERVER	Property Set: DBPROPSET_MSREMOTE_DBINIT Type: VT_BSTR Default value: VT_EMPTY Typical R/W: R/W Remoting Provider property that specifies the name or alias of the remote server.
DBPROP_MULTIPLEPARAMSETS	Property Set: DBPROPSET_DATASOURCEINFO Default value: VARIANT_FALSE Typical R/W: R Standard OLE DB property. Specifies whether or not the (data) provider supports multiple parameter sets.
DBPROP_MULTIPLERESULTS	Property Set: DBPROPSET_DATASOURCEINFO Default value: DBPROPVAL_MR_NOTSUPPORTED Typical R/W: R Standard OLE DB property. A bitmask specifying whether or not the (data) provider supports multiple results objects.
DBPROP_OUTPUTPARAMETERAVAILABILITY	Property Set: DBPROPSET_DATASOURCEINFO Default value: DBPROPVAL_OA_NOTSUPPORTED Typical R/W: R Standard OLE DB property that specifies the time at which output parameter values become available.
DBPROP_PROVIDERFRIENDLYNAME	Property Set: DBPROPSET_DATASOURCEINFO Default value: "MS Remote" Typical R/W: R Standard OLE DB property showing the provider's friendly name.
DBPROP_PROVIDERFILENAME	Property Set: DBPROPSET_DATASOURCEINFO Default value: "Msdarem.dll" Typical R/W: R Standard OLE DB property showing the provider's file name.
DBPROP_PROVIDEROLEDBVER	Property Set: DBPROPSET_DATASOURCEINFO Default value: "2.1" Typical R/W: R Standard OLE DB property showing the OLE DB version supported by the provider.
DBPROP_PROVIDERVER	Property Set: DBPROPSET_DATASOURCEINFO Default value: "2.1.xxxx" for the full version number Typical R/W: R Standard OLE DB property showing the version number of the provider.
DBPROP_SESS_AUTOCOMMITISOLEVELS	Property Set: DBPROPSET_SESSION Default value: DBPROPVAL_TI_CHAOS Typical R/W: R Standard OLE DB property. A bitmask specifying the transaction isolation level while in auto-commit mode.
DBPROP_UNIQUEROWS	Property Set: DBPROPSET_ROWSET Default value: n/a Typical R/W: R/W Standard OLE DB property specifying whether or not each row is uniquely identified by its column values.

Supported OLE DB Properties of the Remoting Provider

Additional resources