Contents

Title and Copyright Information

Send Us Your Comments

Preface

Audience

Organization

Related Documentation

Conventions

Documentation Accessibility

What's New in Oracle Provider for OLE DB?

New Features in Oracle Provider for OLE DB for Release 10.1

New Features in Oracle Provider for OLE DB for Release 9.2.0.4

New Features in Oracle Provider for OLE DB for Release 9.2

New Features in Oracle Provider for OLE DB for Release 9.0.1

New Features in Oracle Provider for OLE DB for Release 8.1.7

1 Introduction to Oracle Provider for OLE DB

Overview of OLE DB

OLE DB Design

Overview of OraOLEDB

System Requirements

OraOLEDB Installation

Component Certifications

2 Features of OraOLEDB

OraOLEDB Provider Specific Features

Datatypes

Binary Datatypes

TIMESTAMP Datatypes

INTERVAL Datatypes

Data Source

Connecting to an Oracle Database

OraOLEDB-specific Connection String Attributes

Default Attribute Values

Distributed Transactions

Operating System Authentication

Password Expiration

OraOLEDB Sessions

Transactions

Commands

Stored Procedures

Preparing Commands

Command Parameters

OraOLEDB Custom Properties for Commands

Stored Procedures and Functions Returning Rowsets

Multiple Rowsets

Rowsets

To Create Rowsets

Updatability

Server Data on Insert Property

To Search 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

OLE DB .NET Data Provider Compatibility

Using the OLEDB.NET Attribute in a Connection String

Using OraOLEDB Custom Properties

Updating Oracle with DataTable Changes

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

Session

Command

Rowset

Multiple Results

Transaction Options

Custom Error Object

MetaData Columns Supported

OraOLEDB Tracing

Registry Setting for Tracing Calls

Glossary

Index