Contents

Title and Copyright Information

Contact Us!

How to Contact Oracle Technical Publications

How to Contact Oracle Support Services

Resources for Oracle Partners and Developers

Preface

Purpose of this Guide

Audience

Feature Coverage and Availability

How this Guide Is Organized

Conventions Used in this Guide

Documentation Library

Related Documents

1 Introduction

Overview of OLE DB

OLE DB Design

System Requirements

Installation

2 OraOLEDB Features

OraOLEDB Provider Specific Features

Data Source Objects

Connecting to an Oracle Database

OraOLEDB-specific Connection String Attributes

Default Attribute Values

OraOLEDB-specific Connection String Attributes for Data Source Objects

OS Authentication

Example: Connecting to an Oracle Database Using ADO

Password Expiration

Sessions

Transactions

Commands

Stored Procedures

Preparing Commands

Command Parameters

OraOLEDB-Specific Connection String Attributes for Commands

Stored Procedures and Functions Returning Rowsets

Example: Stored Procedure Returning Result Set

Rowsets

Creating Rowsets

Updatability

Server Data on Insert Property

Searching for Rows with IRowsetFind::FindNext

OraOLEDB-specific Connection String Attributes for Rowsets

Tips for ADO Programmers

Schema Rowsets

Date Formats

LOB Support

Errors

Example: Using OraOLEDB with Visual Basic

Setting up the Oracle Database

Setting up the Visual Basic Project

A Provider-Specific Information

Datatype Mappings in Rowsets and Parameters

Properties Supported

Data Source Properties

Data Source Info Properties

Initialization and Authorization Properties

Session Properties

Rowset Properties

Rowset Property Implications

Interfaces Supported

Data Source Objects

Sessions

Commands

Rowsets

Transaction Options

Custom Error Objects

MetaData Columns Supported

Index