•  About This Manual
  • Who Should Read This Manual
  • Typographical Conventions
•  Introducing PSQL OLE DB Provider
  • Getting Started with OLE DB Provider
  •  OLE DB Provider Architecture
    • Relational Performance
    • Remote Connections
    • Pessimistic Cursors
    • Support for ADO Refresh Method
    •  Review of Previous OLE DB Providers
      • First Version: Pervasive.SQL 2000i (SP2)
      • Second Version: Pervasive.SQL 2000i (SP3, SP4)
      •  Features in Pervasive.SQL 2000i OLE DB Provider
        • Command-Based Recordsets Supported
        • ADOX
        • Navigational Recordsets in the Provider
        • Large Binary Objects
  •  OLE DB Provider and 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
  • OLE DB Provider Limitations
•  Programming with PSQL OLE DB Provider
  •  Connecting to a Database
    •  Connecting to OLE DB Provider
      • Connect String
      • Sample connection and open
    • Other Tasks
  •  Remote Connections
    • New Syntax Supported
    • Backward Compatibility
  •  Pessimistic Cursors
    • OLE DB Specification and Pessimistic Cursors
    •  Syntax for Pessimistic Cursors
      • Specifying Read Locks vs. Update Locks
    • Summary of Pessimistic Cursor Behavior
    • Sample Visual Basic Code with Pessimistic Cursor
  •  Programming Notes
    • Visibility of Updates
    • Using the OLE DB Provider with a UNC Path or Mapped Drive
    •  Support for ADO Refresh Method Examples
      • Example Using Parameterized Query
      • Example Using Stored Procedure
    • 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
      • Example - Batch Insert
      • Example - Batch Update
•  ADO/OLE DB Reference Information
  •  OLE DB Provider and Visual Basic
    • Non-Visual Programming
    • Visual Programming
  • Creating a Connection
  •  Creating a Recordset
    • Using a Named Database
    • Using a Path
    • Using the Location Parameter
    • 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
      • Single Row Deferred Update Mode
      • Multi-row Deferred Update Mode
  • Using ADO Objects
  • Using Bookmarks
  • Using Events
  • Using the Field Object
  • Using Transactions
•  PSQL OLE DB Provider Implementation
  •  OLE DB Provider Implementation Reference
    •  Command
      • Methods
      • Properties
    •  Connection
      • Methods
      • Properties
      • Events
    •  Field
      • Methods
      • Properties
    •  Fields
      • Methods
      • Properties
    •  Parameter
      • Methods
      • Properties
    • Record
    •  Recordset
      • Methods
      • Properties
    • Stream
  •  ADOX Implementation Reference
    •  Catalog
      • Methods
      • Properties
    •  Columns
      • Methods
      • Properties
    •  Column
      • Properties
    • Group
    •  Index
      • Properties
    •  Indexes
      • Methods
      • Properties
    • Connection
    • Procedure
    •  Tables
      • Methods
      • Properties
    •  Table
      • Properties
  •  Visual Studio.NET Implementation Reference
    • OleDbCommand Methods
    • OleDbCommand Properties
    • OleDbCommandBuilder
    • OleDbConnection Methods
    • OleDbConnection Properties
    • OleDbDataAdapter Methods
    • OleDbDataAdapter Properties
    • DataColumn Properties tested with PSQL OLE DB Provider
    • OleDbDataReader Methods
    • OleDbDataReader Properties
    • DataSet Methods Tested with OLE DB Provider
    • DataSet Properties Tested with OLE DB Provider
    • DataTable Methods Tested with OLE DB Provider
    • DataTable Properties Tested with OLE DB Provider
    • DataRow Methods Tested with OLE DB Provider

About This Manual

PSQL OLE DB Provider Implementation