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

How this Guide Is Organized

Conventions Used in this Guide

Documentation Library

Related Documents

1 Introduction

Overview of OLE DB

OLE DB Design

New and Updated Features for OraOLEDB

System Requirements

Installation

2 OraOLEDB Features

OraOLEDB Provider Specific Features

Data Source

Connecting to an Oracle Database

OraOLEDB-specific Connection String Attributes

Default Attribute Values

Distributed Transactions

OS Authentication

Password Expiration

Sessions

Transactions

Commands

Stored Procedures

Preparing Commands

Command Parameters

OraOLEDB Custom Properties for Commands

Stored Procedures and Functions Returning Rowsets

Multiple Rowsets

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

Case of Object Names

LOB Support

Unicode Support

Types of Unicode Encoding

How Oracle Unicode Support Works

Unicode Support Setup

Errors

Using OraOLEDB with Visual Basic: Example

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

Session

Command

Rowset

Multiple Results

Transaction Options

Custom Error Object

MetaData Columns Supported

OraOLEDB Tracing

Registry Setting for Tracing Calls

Index