Table of Contents

• List of Tables
• Title and Copyright Information
• Preface
  • Audience
  • Documentation Accessibility
  • Related Documents
  • Conventions
• Changes in This Release for Oracle Provider for OLE DB Developer's Guide
  • Changes in Oracle Provider for OLE DB in 12c Release 2 (12.2.0.1)
    • New Features
  • Changes in Oracle Provider for OLE DB in ODAC 12c Release 4
    • New Features
  • Changes in Oracle Provider for OLE DB in 12c Release 1 (12.1.0.2)
    • New Features
• 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 Source
      • 2.1.1.1 Compatibility with OLE DB Services
        • 2.1.1.1.1 ADO Applications with OLE DB Services
        • 2.1.1.1.2 C++/COM Applications with OLE DB Services
      • 2.1.1.2 Connecting to an Oracle Database
      • 2.1.1.3 OraOLEDB-Specific Connection String Attributes
      • 2.1.1.4 Default Attribute Values
      • 2.1.1.5 Distributed Transactions
      • 2.1.1.6 Enhanced Failover Capability
      • 2.1.1.7 Operating System Authentication
      • 2.1.1.8 Password Expiration
      • 2.1.1.9 VCharNull
      • 2.1.1.10 SPPrmDefVal
    • 2.1.2 OraOLEDB Sessions
      • 2.1.2.1 Transactions
        • 2.1.2.1.1 Local Transactions
        • 2.1.2.1.2 Distributed Transactions
    • 2.1.3 Commands
      • 2.1.3.1 Stored Procedures
      • 2.1.3.2 Preparing Commands
      • 2.1.3.3 Command Parameters
      • 2.1.3.4 OraOLEDB Custom Properties for Commands
      • 2.1.3.5 Stored Procedures and Functions Returning Rowsets
      • 2.1.3.6 Multiple Rowsets
      • 2.1.3.7 Statement Caching
      • 2.1.3.8 Metadata Caching
        • 2.1.3.8.1 Enabling Metadata Caching Through the Connection String Attribute
        • 2.1.3.8.2 Enabling Metadata Caching Through the Registry
      • 2.1.3.9 Command Timeout and Cancel Method
        • 2.1.3.9.1 Enabling CommandTimeout Through the Registry
    • 2.1.4 Rowsets
      • 2.1.4.1 To Create Rowsets
      • 2.1.4.2 Updatability
      • 2.1.4.3 Server Data on Insert Property
      • 2.1.4.4 To Search for Rows with IRowsetFind::FindNext
      • 2.1.4.5 OraOLEDB-Specific Connection String Attributes for Rowsets
      • 2.1.4.6 Tips for ADO Programmers
      • 2.1.4.7 Schema Rowsets
      • 2.1.4.8 Date Formats
      • 2.1.4.9 Case of Object Names
      • 2.1.4.10 Performing a Fast Load with SQL Server Integration Services
    • 2.1.5 Data Types
      • 2.1.5.1 Binary Data Types
      • 2.1.5.2 TIMESTAMP Data Types
      • 2.1.5.3 INTERVAL Data Types
    • 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.7.3.1 Database 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