Oracle Provider for OLE DB Developer’s Guide

Based on an open standard, Oracle Provider for OLE DB (OraOLEDB) allows access to Oracle databases. This documentation describes OraOLEDB’s provider-specific features and properties.Oracle Provider for OLE DB Developer’s Guide is intended for programmers developing applications to access an Oracle database using Oracle Provider for OLE DB. This documentation is also valuable to systems analysts, project managers, and others interested in the development of database applications.To use this document, you must be familiar with OLE DB and have a working knowledge of application programming using Microsoft C/C++, Visual Basic, or ActiveX Data Objects (ADO). Knowledge of Component Object Model (COM) concepts are also useful.Readers should also be familiar with the use of Structured Query Language (SQL) to access information in relational database systems.

---

Table of contents :
Contents……Page 3
Send Us Your Comments……Page 7
Preface……Page 9
Related Documentation……Page 10
Conventions……Page 11
Documentation Accessibility……Page 17
What’s New in OraOLEDB?……Page 19
Oracle8i Release 3 (8.1.7) New Features in OraOLEDB……Page 20
1 Introduction to Oracle Provider for OLE DB……Page 21
OLE DB Design……Page 22
System Requirements……Page 23
OraOLEDB Installation……Page 24
2 Features of OraOLEDB……Page 25
Data Source……Page 26
OraOLEDB-specific Connection String Attributes……Page 27
OS Authentication……Page 28
Password Expiration……Page 29
Transactions……Page 30
Preparing Commands……Page 31
OraOLEDB Custom Properties for Commands……Page 32
Stored Procedures and Functions Returning Rowsets……Page 35
Multiple Rowsets……Page 36
To Create Rowsets……Page 39
Updatability……Page 40
To Search for Rows with IRowsetFind::FindNext……Page 41
Tips for ADO Programmers……Page 42
Date Formats……Page 43
Case of Object Names……Page 44
Types of Unicode Encoding……Page 45
Unicode Support Setup……Page 46
Errors……Page 47
Setting Up the Oracle Database……Page 48
Setting Up the Visual Basic Project……Page 49
A Provider-Specific Information……Page 55
Datatype Mappings in Rowsets and Parameters……Page 56
Data Source Info Properties……Page 57
Initialization and Authorization Properties……Page 59
Rowset Properties……Page 60
Rowset Property Implications……Page 64
Session……Page 65
Multiple Results……Page 66
MetaData Columns Supported……Page 67
Registry Setting for Tracing Calls……Page 68
Glossary……Page 71
Index……Page 73