Contents

Title and Copyright Information

Preface

Audience

Documentation Accessibility

Related Documents

Conventions

What's New in OraOLEDB?

New Features in Oracle Provider for OLE DB for Release 10.2

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

Data Types

Binary Data Types

TIMESTAMP Data Types

INTERVAL Data Types

Data Source

Connecting to an Oracle Database

OraOLEDB-specific Connection String Attributes

Default Attribute Values

Distributed Transactions

Operating System Authentication

Password Expiration

VCharNull

SPPrmDefVal

OraOLEDB Sessions

Transactions

Commands

Stored Procedures

Preparing Commands

Command Parameters

OraOLEDB Custom Properties for Commands

Stored Procedures and Functions Returning Rowsets

Multiple Rowsets

Statement Caching

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

OLEDB.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

Data Type Mappings in Rowsets and Parameters

Properties Supported

Data Source Properties

DataSourceInfo 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