Table of Contents
- List of Tables
- Title and Copyright Information
- Preface
- Changes in This Release for Oracle Provider for OLE DB Developer's Guide
- 1 Introduction to Oracle Provider for OLE DB
- 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.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.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.9 Command Timeout and Cancel Method
- 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.6 LOB Support
- 2.1.7 Unicode Support
- 2.1.8 Errors
- 2.1.9 OLEDB.NET Data Provider Compatibility
- 2.1.1
Data Source
- 2.2 Using OraOLEDB with Visual Basic
- 2.1
OraOLEDB Provider Specific Features
- A Provider-Specific Information
- Glossary
- Index