OLE DB Provider Guide - Table of Contents

Pervasive.SQL (code OLE_910, revision 1)  Sync manual in Pervasive Library

About This Manual

Who Should Read This Manual

Manual Organization

Conventions

Pervasive OLE DB Provider Introduction

Pervasive OLE DB Introduction

Pervasive OLE DB Architecture

Relational Performance

Remote Connections

Pessimistic Cursors

Support for ADO Refresh Method

Review of Previous OLE DB Providers

Support for Visual Studio.NET

Wizards in Visual Studio.NET

Security with ASP.NET

Supported Objects

Performance Considerations with OLE DB

Cache Engine

Best Performance is Navigational

Static vs. Dynamic Cursors

Disable Unused Services

Limitations of the OLE DB Provider

Programming with the Pervasive OLE DB Provider

Connecting to a Database Using the OLE DB Provider

Connecting to OLE DB Provider

Other Tasks

Remote Connections

New Syntax Supported

Backward Compatibility

Pessimistic Cursors

OLE DB Specification and Pessimistic Cursors

Syntax for Pessimistic Cursors

Summary of Pessimistic Cursor Behavior

Sample Visual Basic Code with Pessimistic Cursor

Programming Notes for Pervasive OLE DB Provider

Visibility of Updates

Using the OLE DB Provider with a UNC Path or Mapped Drive

Support for ADO Refresh Method Examples

Programming Notes for Pervasive OLE DB Provider

Seek with Static Cursors

Remote Connections

Table Definitions

Default LockType

Initialization Properties

COM+ Services Support

What is COM+ Services?

Example of COM+ Services for Visual Basic Programmers

Execute Method (ADO Command)

SELECT operations

Batch Insert, Update, or Delete

ADO/OLE DB Reference Information

Setting up Visual Basic for Pervasive.SQL OLE DB Programming

Non-Visual Programming

Visual Programming

Creating a Connection

Creating a Recordset Using a Named Database

Creating a Recordset Using a Path

Creating a Recordset Using the Location Parameter

Creating a Recordset Using an Existing Connection

Navigating Through and Manipulating Data

Adding Records

Deleting Records

Updating Records

Searching for Records

Selecting Deferred-Update or Immediate-Update

Immediate-update mode

Deferred-Update Modes

Using ADO Objects

Using Bookmarks

Using Events

Using the Field Object

Using Transactions

Pervasive.SQL OLE DB Provider Implementation

Pervasive.SQL OLE DB Provider Implementation Reference

Command

Connection

Field

Fields

Parameter

Record

Recordset

Stream

ADOX Implementation Reference

Catalog

Columns

Column

Group

Index

Indexes

Connection

Procedure

Tables

Table

Visual Studio.NET Implementation Reference