Provider-Defined Properties in DBPROPSET_JETOLEDB_SESSION

The DBPROPSET_JETOLEDB_SESSION property set contains the following properties. Each of these properties must be set using the Properties property of the connection object. When the properties are set in the connection string the error "Could not find installable ISAM Error Code: 0x8004005" will occur.

Property ID

Description

DBPROP_JETOLEDB_CONNECTIONCONTROL

Type: VT_I4

Typical R/W: R/W

Description: Jet OLEDB:Connection Control

Controls the ability to connect to the database.

  • DBPROPVAL_JCC_PASSIVESHUTDOWN ? Disallow new connections to the database.

  • DBPROPVAL_JCC_NORMAL ? Allow users to connect to the database.

DBPROP_JETOLEDB_EXCLUSIVEASYNCDELAY

Type: VT_I4

Typical R/W: R/W

Description: Jet OLEDB:Exclusive Async Delay

The maximum time Jet can delay asynchronous writes to disk, in milliseconds, when the database is opened exclusively.

This property is ignored unless the DBPROP_JETOLEDB_FLUSHTRANSACTIONTIMEOUT property is 0.

DBPROP_JETOLEDB_FLUSHTRANSACTIONTIMEOUT

Type: VT_I4

Typical R/W: R/W

Description: Jet OLEDB:Flush Transaction Timeout

The amount of time of inactivity before the asynchronous write cache is flushed to disk. This setting precludes the values for Shared Async Delay and Exclusive Async Delay.

DBPROP_JETOLEDB_IMPLICITCOMMITSYNC

Type: VT_BOOL

Typical R/W: R/W

Description: Jet OLEDB:Implicit Commit Sync

Determines whether changes made in internal implicit transactions are written in synchronous or asynchronous mode.

  • VARIANT_TRUE ? Changes are written synchronously.

  • VARIANT_FALSE ? Changes are written asynchronously.

DBPROP_JETOLEDB_LOCKDELAY

Type: VT_I4

Typical R/W: R/W

Description: Jet OLEDB:Lock Delay

This property determines how long to wait, in milliseconds, before attempting to acquire a lock after the previous attempt has failed.

DBPROP_JETOLEDB_LOCKRETRY

Type: VT_I4

Typical R/W: R/W

Description: Jet OLEDB:Lock Retry

The number of times to repeat attempts to access a locked page.

DBPROP_JETOLEDB_MAXBUFFERSIZE

Type: VT_I4

Typical R/W: R/W

Description: Jet OLEDB:Max Buffer Size

The largest amount of memory, in kilobytes, that Jet can use before it starts flushing changes to disk.

DBPROP_JETOLEDB_MAXLOCKSPERFILE

Type:VT_I4

Typical R/W: R/W

Description: Jet OLEDB:Max Locks Per File

The maximum number of locks that Jet can place on a database. The default for this property is 9500.

DBPROP_JETOLEDB_ODBCCOMMANDTIMEOUT

Type: VT_I4

Typical R/W: R/W

Description: Jet OLEDB:ODBC Command Timeout

Number of seconds before remote ODBC queries from Jet timeout.

DBPROP_JETOLEDB_PAGETIMEOUT

Type: VT_I4

Typical R/W: R/W

Description: Jet OLEDB:Page Timeout

The amount of time, in milliseconds, that Jet will wait before checking to see if its cache is out of date with the database file.

DBPROP_JETOLEDB_RECYCLELONGVALUEPAGES

Type: VT_BOOL

Typical R/W: R/W

Description: Jet OLEDB:Recycle Long-Valued Pages

Whether Jet should aggressively try to reclaim BLOB pages when they are freed.

  • VARIANT_TRUE ? Long value pages will become available for reuse after Microsoft Jet determines that there is only one user in the database in shared mode and that new long value data has been added to the database.

  • VARIANT_FALSE ? Discarded long value pages will continue to occupy space in the database and become available for reuse only after the last user closes the database.

DBPROP_JETOLEDB_RESETISAMSTATS

Type: VT_BOOL

Typical R/W: R/W

Description: Jet OLEDB:Reset ISAM Stats

Determines whether the schema rowset DBSCHEMA_JETOLEDB_ISAMSTATS should reset its performance counters after returning performance information.

  • VARIANT_TRUE ? Reset the ISAM performance counters to their initial values after generating the schema rowset.

  • VARIANT_FALSE ? Do not reset the ISAM performance counters.

DBPROP_JETOLEDB_SHAREDASYNCDELAY

Type: VT_I4

Typical R/W: R/W

Description: Jet OLEDB:Shared Async Delay

The maximum time Jet can delay asynchronous writes to disk, in milliseconds, when the database is opened in multiuser mode.

This property is ignored unless the DBPROP_JETOLEDB_FLUSHTRANSACTIONTIMEOUT property is 0.

DBPROP_JETOLEDB_USERCOMMITSYNC

Type: VT_BOOL

Typical R/W: R/W

Description: Jet OLEDB:User Commit Sync

Determines whether changes made in user explicit transactions are written in synchronous or asynchronous mode.

  • VARIANT_TRUE ? Changes are written synchronously.

  • VARIANT_FALSE ? Changes are written asynchronously.