Pervasive.SQL OLE DB Provider Implementation Reference

Show this topic in Library frames

This section lists specifics with regard to Pervasive's implementation of the OLE DB provider.

Note
No Asynchronous operations are supported.

Command

Methods

Supported

CreateParameter

Execute

Unsupported

Cancel

Properties

Supported

ActiveConnection

CommandText

CommandType

Name

Parameters

Prepared

Properties

State

Connection

Methods

Supported

BeginTrans (including nested transactions)

CommitTrans

Execute

Open

adConnectUnspecified

OpenSchema

RollbackTrans

Unsupported

Cancel

Properties

Supported

Attributes

ConnectionString

CursorLocation

adUseClient should only be used after researching Microsoft's Client Cursor Engine

Errors

IsolationLevels

adXactRepeatableRead and adXactSerializable

Mode

adModeReadWrite

Properties

Provider

Version

Unsupported

CommandTimeout

ConnectionTimeout

DefaultDatabase

Events

Supported

CommitTransComplete

ConnectComplete

Disconnect

ExecuteComplete

EndOfRecordset

FieldChangeComplete

MoveComplete

RollbackTransComplete

WillExecute

WillChangeField

WillConnect

WillMove

Unsupported

InfoMessage

Field

Methods

Supported

AppendChunk

GetChunk

Properties

Supported

ActualSize

This gives the size that we hold in the database

This is only accurate to 65k on LongVarBinary and LongVarChar, after that the length can only be found using GetChunk

Attributes

DataFormat

DefinedSize

Name

NumericScale

OriginalValue

Precision

Properties

Status

Type

Value

Unsupported

UnderlyingValue

Fields

Methods

Unsupported

Append

CancelUpdate

Delete

Refresh

Resynch

Update

Properties

Supported

Count

Item

Parameter

Methods

Supported

Appendchunk

Properties

Supported

Attributes

Direction

Name

NumericScale

Precision

Properties

Size

Type

Value

Record

Not Supported

Recordset

Methods

Supported

AddNew

Cancel

CancelBatch

CancelUpdate

Clone

CompareBookmark

Delete

Find

GetRows

GetString

Move

MoveFirst

MoveLast

MoveNext

MovePrevious

Open

Resync

Save

Seek

supported when using adCmdTableDirect

Supports

Update

UpdateBatch

Unsupported

Requery

Properties

Supported

AbsolutePage

AbsolutePosition

ActiveCommand

ActiveConnection

BOF

Bookmark

CacheSize

CursorLocation

CursorType

adOpenStatic, adOpenDynamic, and adOpenForwardOnly

DataSource

EditMode

EOF

Fields

Filter

Do not support views

Index

With adCmdTableDirect

Locktype

adLockOptimistic, adLockBatchOptimistic, and adLockReadOnly

MarshalOptions

MaxRecords

PageCount

PageSize

Properties

RecordCount

Sort

Source

State

Status

StayInSync

Stream

Not Supported