Index

A C D E F G H I K L M N O P R S T U V

A

AD AT

ADO, 2.1.2.1, 2.1.2.8, 2.1.4.6

ADO Applications with OLE DB Services, 2.1.2.1.1

ADO.NET, 2.1.9

attributes

connection string, 2.1.2.3

C

CA CH CL CO CR CU

connection string, 2.1.9.1

example, 2.1.9.1

C++/COM, 2.1.2.1

C++/COM Applications with OLE DB Services, 2.1.2.1.2

CacheType

connection string attribute for rowsets, 2.1.2.3, 2.1.5.5

caching, 2.1.4.8

Cancel method, 2.1.4.9

case of object names, 2.1.5.9

ChunkSize

connection string attribute for rowsets, 2.1.2.3, 2.1.5.5

class ID

CLSID_OraOLEDB, 2.1.2

CLSCTX_INPROC_SERVER macro, 2.1.2

CLSID_MSDAINITIALIZE class, 2.1.2.1.1

CoCreateInstance

creating an instance of the data source object, 2.1.2

columns

metadata, A.4

commands, 2.1.4

parameters, 2.1.4.3

preparing, 2.1.4.2

CommandTimeout property, 2.1.4.9

compatibility with OLE DB Services, 2.1.2.1

Component Certifications

My Oracle Support, 1.5

connecting

Oracle databases supported, 2.1.2

to a specific database, 2.1.2

to an Oracle database, 2.1.2.2

to an Oracle database using ADO, 2.1.2.8

connection string attributes, 2.1.2.3

defaults, 2.1.2.4

registry, 2.1.2.4

rowsets, 2.1.5.5

consumers

OLE DB, 1.1.1

creating

an instance of the data source object, 2.1.2

rowsets, 2.1.5.1

Cursor Stability, 2.1.3.1.1

CursorType

tips for ADO programmers, 2.1.5.6

custom error objects

interfaces supported, A.3.7

D

DA DB DE DI

data source

creating an instance of, 2.1.2

distributed transactions, 2.1.2.5

objects, 2.1.2

properties, A.2.1

data source info

properties, A.2.2

DataTable, 2.1.9.3

datatypes

mappings between Oracle datatypes and OLE DB types, A.1

mappings in rowsets and parameters, A.1

OLE DB, A.1

Oracle, A.1, A.1

date formats

NLS_DATE_FORMAT, 2.1.5.8

settings, 2.1.5.8

DBNotificationPort, 2.1.2.3, 2.1.2.6

DBNotifications, 2.1.2.3, 2.1.2.6

DBPROP_AUTH_PASSWORD property

setting, 2.1.2

DBPROP_AUTH_USERNAME property

enabling operating system authentication, 2.1.2.7

setting, 2.1.2

DBPROP_INIT_DATASOURCE property

setting, 2.1.2

DBPROP_INIT_OLEDBSERVICES property, 2.1.2.1

DBPROP_INIT_PROMPT property

setting, 2.1.2

DBPROP_INIT_PROVIDERSTRING property

enabling operating system authentication, 2.1.2.7

setting, 2.1.2.4

DBPROP_IROWSETUPDATE property

setting of other properties, A.2.5.1

DBPROP_SERVERDATAONINSERT property, 2.1.5.3

DBPROPSET_DBINIT property set

setting properties, 2.1.2, 2.1.2.4

debugging, A.5

DeferUpdChk, 2.1.2.3, 2.1.5.5

connection string attribute to indicate whether to defer updateability, 2.1.5.5

demobld.sql, 2.2.1, 2.2.1

design

OLE DB, 1.1.1

DistribTX

connection string attribute for commands, 2.1.2.3

Distributed Transactions, 2.1.2.5

distributed transactions, 2.1.3.1.2

E

EN ER EX

EnableCmdTimeout registry value, 2.1.4.9.1

Enhanced Failover Capability, 2.1.2.6

enlistment, 2.1.2.5

distributed transactions, 2.1.2.5

errors

HRESULT, 2.1.8

OLE and COM, 2.1.8

examples, 2.1.9.1, 2.1.9.1

connecting to an Oracle database using ADO, 2.1.2.8

stored procedure returning multiple rowsets, 2.1.4.6

using OraOLEDB with Visual Basic, 2.2

F

FE FI

features

new, Preface

Oracle Provider for OLE DB, 2.1

FetchSize

connection string attribute for rowsets, 2.1.2.3, 2.1.5.5

files

installed on system for Oracle Provider for OLE DB, 1.4

Oracle Provider for OLE DB, 1.4

G

global transactions, 2.1.3.1.2

H

HRESULT

error return code, 2.1.8

I

initialization and authorization

properties, A.2.3

installation, 1.4

files for Oracle Provider for OLE DB, 1.4

interface call traces, A.5

interfaces

custom error objects, A.3.7

rowsets, A.3.4

sessions, A.3.2

supported by Oracle Provider for OLE DB, A.3

transaction options, A.3.6

K

KEY_HOMENAME, 2.1.2.4

L

LOB support, 2.1.6

ISequentialStream interface, 2.1.6

LockType

tips for ADO programmers, 2.1.5.6

M

MD ME MI MT MY

MDAC, 1.3

metadata, 2.1.4.8

metadata caching, 2.1.4.8

metadata columns

supported by Oracle Provider for OLE DB, A.4

MetaDataCacheSize, 2.1.2.3

Microsoft Data Access Components, 1.3

Microsoft Distributed Transaction Coordinator, 2.1.3.1.2

Microsoft Transaction Server, 2.1.3.1.2

MTS, see Microsoft Transaction Server

My Oracle Support, 1.5

N

ND NE

NDataType, 2.1.2.3

NDatatype, 2.1.4.4

.NET, 2.1.9

New Features in Oracle Provider for OLE DB for Release 11.1, Preface

New Features in Oracle Provider for OLE DB for Release 11.1.0.7.20, Preface

O

OB OL OP OR OS

object names

case, 2.1.5.9

OLE DB

consumers, 1.1.1

datatypes, A.1

design, 1.1.1

Microsoft web site, 1.3

providers, 1.1.1

OLE DB .NET Data Provider, 2.1.2.3

compatibility, 2.1.9

OLE DB Services

ADO Applications with, 2.1.2.1.1

C++/COM Applications with, 2.1.2.1.2

compatibility with, 2.1.2.1

OleDbDataAdapter.Update(), 2.1.9.3

OLEDB.NET, 2.1.2.3, 2.1.9

operating system authentication, 2.1.2.7

DBPROP_INIT_PROVIDERSTRING, 2.1.2.7, 2.1.2.7

Oracle

datatypes, A.1, A.1

Oracle Provider for OLE DB

class ID, 2.1.2

features, 2.1

provider-specific information, A

system requirements, 1.3

Oracle Services for Microsoft Transaction Server, 1.3, 2.1.3.1.2

OracleMetaLink, 1.5

OraOLEDB sessions, 2.1.3

OSAuthent

connection string attribute for data source, 2.1.2.3

enabling operating system authentication, 2.1.2.7

P

PA PE PL PR PW

password expiration

connection string attribute, 2.1.2.8

PwdChgDlg, 2.1.2.8

performance, 2.1.4.8

PLSQLRSet, 2.1.4.4

connection string attribute for commands, 2.1.2.3

properties

data source, A.2.1

data source info, A.2.2

initialization and authorization, A.2.3

rowset, A.2.5

rowset implications, A.2.5.1

sessions, A.2.4

supported by Oracle Provider for OLE DB, A.2

providers

OLE DB, 1.1.1

PwdChgDlg

connection string attribute for commands, 2.1.2.3

connection string attribute for data source, 2.1.2.8

R

RE RO

registry

default attribute values, 2.1.2.4

returning rowsets

stored procedures and functions, 2.1.4.5

ROWID, 2.1.9.3

rowsets, 2.1.5

creating, 2.1.5.1

creating with ICommand, 2.1.5.1

creating with IOpenRowset, 2.1.5.1

date formats, 2.1.5.8

interfaces supported, A.3.4

properties, A.2.5

property implications, A.2.5.1

returning with procedures and functions, 2.1.4.5

schema, 2.1.5.7

searching with IRowsetFind, 2.1.5.4

updatability, 2.1.5.2

S

SC SE SP ST SY

schema rowsets, 2.1.5.7

Server Data on Insert property, 2.1.5.3

sessions

interfaces supported, A.3.2

objects, 2.1.3

properties, A.2.4

SPPrmDefVal, 2.1.2.3

SPPrmsLOB, 2.1.2.3, 2.1.4.4

StmtCacheSize, 2.1.2.3

stored procedures and functions

executing, 2.1.4.1

returning rowsets, 2.1.4.5

system requirements

Oracle Provider for OLE DB, 1.3

T

TI TR

tips

for ADO programmers, 2.1.5.6

TraceCategory, A.5.1

TraceFileName, A.5.1

TraceLevel, A.5.1

tracing, A.5

transaction options

interfaces supported, A.3.6

transactions

distributed, 2.1.3.1.2

global, 2.1.3.1.2

isolation levels, 2.1.3.1.1

local, 2.1.3.1.1

types supported, 2.1.3.1

U

UC UN US

UCS-2 character set, 2.1.7

Unicode, 2.1.7

UseSessionFormat

connection string attribute for commands, 2.1.2.3

V

VB VC

VB.NET

connection string, 2.1.9.1

examples, 2.1.9.1

VCharNull, 2.1.2.3