Skip Headers

Oracle® Provider for OLE DB Developer's Guide
10g Release 1 (10.1)

Part Number B10115-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
Feedback

Go to next page
Next
View PDF

Contents

Title and Copyright Information

Send Us Your Comments

Preface

Audience
Organization
Related Documentation
Conventions
Documentation Accessibility

What's New in Oracle Provider for OLE DB?

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
Datatypes
Binary Datatypes
TIMESTAMP Datatypes
INTERVAL Datatypes
Data Source
Connecting to an Oracle Database
OraOLEDB-specific Connection String Attributes
Default Attribute Values
Distributed Transactions
Operating System Authentication
Password Expiration
OraOLEDB Sessions
Transactions
Commands
Stored Procedures
Preparing Commands
Command Parameters
OraOLEDB Custom Properties for Commands
Stored Procedures and Functions Returning Rowsets
Multiple Rowsets
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
OLE DB .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

Datatype Mappings in Rowsets and Parameters
Properties Supported
Data Source Properties
Data Source Info 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