Contents

List of Figures

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 11.1
• 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

• 1.1 Overview of OLE DB
  • 1.1.1 OLE DB Design
• 1.2 Overview of OraOLEDB
• 1.3 System Requirements
• 1.4 OraOLEDB Installation
• 1.5 Component Certifications

2 Features of OraOLEDB

• 2.1 OraOLEDB Provider Specific Features
  • 2.1.1 Data Types
    • 2.1.1.1 Binary Data Types
    • 2.1.1.2 TIMESTAMP Data Types
    • 2.1.1.3 INTERVAL Data Types
  • 2.1.2 Data Source
    • 2.1.2.1 Connecting to an Oracle Database
    • 2.1.2.2 OraOLEDB-Specific Connection String Attributes
    • 2.1.2.3 Default Attribute Values
    • 2.1.2.4 Distributed Transactions
    • 2.1.2.5 Enhanced Failover Capability
    • 2.1.2.6 Operating System Authentication
    • 2.1.2.7 Password Expiration
    • 2.1.2.8 VCharNull
    • 2.1.2.9 SPPrmDefVal
  • 2.1.3 OraOLEDB Sessions
    • 2.1.3.1 Transactions
  • 2.1.4 Commands
    • 2.1.4.1 Stored Procedures
    • 2.1.4.2 Preparing Commands
    • 2.1.4.3 Command Parameters
    • 2.1.4.4 OraOLEDB Custom Properties for Commands
    • 2.1.4.5 Stored Procedures and Functions Returning Rowsets
    • 2.1.4.6 Multiple Rowsets
    • 2.1.4.7 Statement Caching
    • 2.1.4.8 Metadata Caching
  • 2.1.5 Rowsets
    • 2.1.5.1 To Create Rowsets
    • 2.1.5.2 Updatability
    • 2.1.5.3 Server Data on Insert Property
    • 2.1.5.4 To Search for Rows with IRowsetFind::FindNext
    • 2.1.5.5 OraOLEDB-Specific Connection String Attributes for Rowsets
    • 2.1.5.6 Tips for ADO Programmers
    • 2.1.5.7 Schema Rowsets
    • 2.1.5.8 Date Formats
    • 2.1.5.9 Case of Object Names
  • 2.1.6 LOB Support
  • 2.1.7 Unicode Support
    • 2.1.7.1 Types of Unicode Encoding
    • 2.1.7.2 How Oracle Unicode Support Works
    • 2.1.7.3 Unicode Support Setup
  • 2.1.8 Errors
  • 2.1.9 OLEDB.NET Data Provider Compatibility
    • 2.1.9.1 Using the OLEDB.NET Attribute in a Connection String
    • 2.1.9.2 Using OraOLEDB Custom Properties
    • 2.1.9.3 Updating Oracle with DataTable Changes
• 2.2 Using OraOLEDB with Visual Basic
  • 2.2.1 Setting Up the Oracle Database
  • 2.2.2 Setting Up the Visual Basic Project

A Provider-Specific Information

• A.1 Data Type Mappings in Rowsets and Parameters
• A.2 Properties Supported
  • A.2.1 Data Source Properties
  • A.2.2 DataSourceInfo Properties
  • A.2.3 Initialization and Authorization Properties
  • A.2.4 Session Properties
  • A.2.5 Rowset Properties
    • A.2.5.1 Rowset Property Implications
• A.3 Interfaces Supported
  • A.3.1 Data Source
  • A.3.2 Session
  • A.3.3 Command
  • A.3.4 Rowset
  • A.3.5 Multiple Results
  • A.3.6 Transaction Options
  • A.3.7 Custom Error Object
• A.4 MetaData Columns Supported
• A.5 OraOLEDB Tracing
  • A.5.1 Registry Setting for Tracing Calls

Glossary

Index