MDAC 2.5 SDK - OLE DB Providers
OLE DB Remoting Provider


 

Supported OLE DB Properties of the Remoting Provider

                   

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.