Contents

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 Database 12c Release 1 (12.1.0.2)

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 Source
    • Compatibility with OLE DB Services
    • Connecting to an Oracle Database
    • OraOLEDB-Specific Connection String Attributes
    • Default Attribute Values
    • Distributed Transactions
    • Enhanced Failover Capability
    • 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
    • Metadata Caching
    • Command Timeout and Cancel Method
  • 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
    • Performing a Fast Load with SQL Server Integration Services
  • Data Types
    • Binary Data Types
    • TIMESTAMP Data Types
    • INTERVAL Data Types
  • 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