Export (0) Print
Expand All

Supported OLE DB Properties of the Remoting Provider

Important note 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.

Show:
© 2014 Microsoft