Skip Headers
Oracle® Provider for OLE DB Developer's Guide
10g Release 2 (10.2)

Part Number B14311-01
Go to Documentation Home
Home
Go to Book List
Book List
Go to Index
Index
Go to Master Index
Master Index
Go to Feedback page
Contact Us

Go to next page
Next
PDF · Mobi · ePub

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