Oracle Provider for OLE DB User's Guide -- Index

ActiveX Data Objects, xviii

ADO, 2-5, 2-13

attributes

connection string, 2-3

CacheType

connection string attribute for rowsets, 2-3, 2-17

case of object names, 2-20

ChunkSize

connection string attribute for rowsets, 2-3, 2-18

class ID

CLSID_OraOLEDB, 2-2

CLSCTX_INPROC_SERVER macro, 2-2

CoCreateInstance

creating an instance of the data source object, 2-2

columns

metadata, A-13

COM

Component Object Model, xviii

commands

object, 2-7

parameters, 2-8

preparing, 2-7

Component Object Model (COM), xviii

connecting

Oracle databases supported, 2-3

to a specific database, 2-3

to an Oracle database, 2-3

to an Oracle database using ADO, 2-5

connection string attributes, 2-3

defaults, 2-4

registry, 2-4

rowsets, 2-17

consumers

OLE DB, 1-3

conventions used in this guide, xix

creating

an instance of the data source object, 2-2

rowsets, 2-15

Cursor Stability, 2-7

CursorType

tips for ADO programmers, 2-18

custom error objects

interfaces supported, A-13

Customer Support

contacting, vii

data source

creating an instance of, 2-2

distributed transactions, 2-4

objects, 2-2

properties, A-3

data source info

properties, A-3

datatypes

mappings between Oracle datatypes and OLE DB types, A-2

mappings in rowsets and parameters, A-2

OLE DB, A-2

Oracle, A-2

date formats

NLS_DATE_FORMAT, 2-19

settings, 2-19

DBPROP_ABORTPRESERVE property, A-6

DBPROP_ACCESSORORDER property, A-6

DBPROP_ACTIVESESSIONS property, A-3

DBPROP_APPENDONLY property, A-6

DBPROP_ASYNCTXNABORT property, A-3

DBPROP_ASYNCTXNCOMMIT property, A-3

DBPROP_AUTH_PASSWORD property

setting, 2-3

DBPROP_AUTH_PERSIST_SENSITIVE_AUTHINFO property, A-5

DBPROP_AUTH_USERID property, A-5

DBPROP_AUTH_USERNAME property

enabling OS authentication, 2-5

setting, 2-3

DBPROP_BLOCKINGSTORAGEOBJECTS property, A-6

DBPROP_BOOKMARKINFO property, A-6

DBPROP_BOOKMARKS property, A-6

DBPROP_BOOKMARKSKIPPED property, A-6

DBPROP_BOOKMARKTYPE property, A-6

DBPROP_BYREFACCESSORS property, A-3

DBPROP_CACHEDEFERRED property, A-6

DBPROP_CANFETCHBACKWARDS property, A-6

DBPROP_CANHOLDROWS property, A-6

DBPROP_CANSCROLLBACKWARDS property, A-6

DBPROP_CATALOGLOCATION property, A-3

DBPROP_CATALOGTERM property, A-3

DBPROP_CATALOGUSAGE property, A-3

DBPROP_CHANGEINSERTEDROWS property, A-6

DBPROP_CLIENTCURSOR property, A-7

DBPROP_COLUMNDEFINITION property, A-3

DBPROP_COLUMNRESTRICT property, A-7

DBPROP_COMMANDTIMEOUT property, A-7

DBPROP_COMMITPRESERVE property, A-7

DBPROP_CONCATNULLBEHAVIOR property, A-3

DBPROP_CONNECTIONSTATUS property, A-3

DBPROP_CURRENTCATALOG property, A-3

DBPROP_DATASOURCENAME property, A-4

DBPROP_DATASOURCEREADONLY property, A-4

DBPROP_DBMSNAME property, A-4

DBPROP_DBMSVER property, A-4

DBPROP_DEFERRED property, A-7

DBPROP_DELAYSTORAGEOBJECTS property, A-7

DBPROP_DSOTHREADMODEL property, A-4

DBPROP_FINDCOMPAREOPS property, A-7

DBPROP_GROUPBY property, A-4

DBPROP_HETEROGENEOUSTABLES property, A-4

DBPROP_HIDDENCOLUMNS property, A-7

DBPROP_IACCESSOR property, A-7

DBPROP_ICOLUMNSINFO property, A-7

DBPROP_ICOLUMNSROWSET property, A-7

DBPROP_ICONNECTIONPOINTCONTAINER property, A-7

DBPROP_ICONVERTTYPE property, A-7

DBPROP_IDENTIFIERCASE property, A-4

DBPROP_IMMOBILEROWS property, A-7

DBPROP_INIT_DATASOURCE property, A-5

setting, 2-3

DBPROP_INIT_HWND property, A-6

DBPROP_INIT_LCID property, A-6

DBPROP_INIT_OLEDBSERVICES property, A-6

DBPROP_INIT_PROMPT property, A-6

setting, 2-3

DBPROP_INIT_PROVIDERSTRING property

enabling OS authentication, 2-5

setting, 2-4

DBPROP_IROWSET property, A-7

DBPROP_IROWSETCHANGE property, A-7

DBPROP_IROWSETFIND property, A-7

DBPROP_IROWSETIDENTITY property, A-7

DBPROP_IROWSETINFO property, A-7

DBPROP_IROWSETLOCATE property, A-7

setting of other properties, A-10

DBPROP_IROWSETREFRESH property, A-7

DBPROP_IROWSETSCROLL property, A-7

setting of other properties, A-10

DBPROP_IROWSETUPDATE property, A-7

setting of other properties, A-10

DBPROP_ISEQUENTIALSTREAM property, A-7

DBPROP_ISUPPORTERRORINFO property, A-7

DBPROP_LITERALBOOKMARKS property, A-7

DBPROP_LITERALIDENTITY property, A-8

DBPROP_LOCKMODE property, A-8

DBPROP_MAXINDEXSIZE property, A-4

DBPROP_MAXOPENCHAPTERS property, A-4

DBPROP_MAXOPENROWS property, A-8

DBPROP_MAXORSINFILTER property, A-4

DBPROP_MAXPENDINGROWS property, A-8

DBPROP_MAXROWS property, A-8

DBPROP_MAXROWSIZE property, A-4, A-8

DBPROP_MAXROWSIZEINCLUDESBLOB property, A-4, A-8

DBPROP_MAXSORTCOLUMNS property, A-4

DBPROP_MAXTABLESINSELECT property, A-4

DBPROP_MULTIPLEPARAMSETS property, A-4

DBPROP_MULTIPLERESULTS property, A-4

DBPROP_MULTIPLESTORAGEOBJECTS property, A-4

DBPROP_MULTITABLEUPDATE property, A-4

DBPROP_NOTIFICATIONGRANULARITY property, A-8

DBPROP_NOTIFICATIONPHASES property, A-8

DBPROP_NOTIFYCOLUMNSET property, A-8

DBPROP_NOTIFYROWDELETE property, A-8

DBPROP_NOTIFYROWFIRSTCHANGE property, A-8

DBPROP_NOTIFYROWINSERT property, A-8

DBPROP_NOTIFYROWRESYNCH property, A-8

DBPROP_NOTIFYROWSETFETCHPOSITIONCHANGE property, A-8

DBPROP_NOTIFYROWSETRELEASE property, A-8

DBPROP_NOTIFYROWUNDOCHANGE property, A-9

DBPROP_NOTIFYROWUNDODELETE property, A-9

DBPROP_NOTIFYROWUNDOINSERT property, A-9

DBPROP_NOTIFYROWUNDOUPDATE property, A-9

DBPROP_NULLCOLLATION property, A-4

DBPROP_ORDEREDBOOKMARKS property, A-9

DBPROP_OTHERINSERT property, A-9

DBPROP_OTHERUPDATEDELETE property, A-9

DBPROP_OWNINSERT property, A-9

DBPROP_OWNUPDATEDELETE property, A-9

DBPROP_QUICKRESTART property, A-9

DBPROP_REENTRANTEVENTS property, A-9

DBPROP_REMOVEDELETED property, A-9

DBPROP_REPORTMULTIPLECHANGES property, A-9

DBPROP_RETURNPENDINGINSERTS property, A-9

DBPROP_ROWRESTRICT property, A-9

DBPROP_ROWTHREADMODEL property, A-9

DBPROP_SERVERCURSOR property, A-9

DBPROP_SERVERDATAONINSERT property, 2-17, A-9

DBPROP_SESS_AUTOCOMMITISOLEVELS property, A-6

DBPROP_STRONGIDENTITY property, A-9

DBPROP_TRANSACTEDOBJECT property, A-9

DBPROP_UNIQUEROWS property, A-10

DBPROP_UPDATABILITY property, A-10

DBPROPSET_DBINIT property set

setting properties, 2-3, 2-4

debugging, A-14

design

OLE DB, 1-2

DistribTX

connection string attribute for commands, 2-3

Distributed Transactions, 2-4

distributed transactions, 2-7

documentation

generic, xxi

enlistment

distributed transactions, 2-4

error messages

resolving, vii

errors

HRESULT, 2-23

OLE and COM, 2-23

examples

connecting to an Oracle database using ADO, 2-5

stored procedure returning multiple rowsets, 2-12

using OraOLEDB with Visual Basic, 2-24

features

Oracle Provider for OLE DB, 2-2

FetchSize

connection string attribute for rowsets, 2-4, 2-18

files

installed on system for Oracle Provider for OLE DB, 1-5

Oracle Provider for OLE DB, 1-5

global transactions, 2-7

HRESULT

error return code, 2-23

initialization and authorization

properties, A-5

installation

files for Oracle Provider for OLE DB, 1-5

Oracle Provider for OLE DB, 1-5

interface call traces, A-14

interfaces

custom error objects, A-13

rowsets, A-12

sessions, A-11

supported by Oracle Provider for OLE DB, A-11

transaction options, A-13

LOB support, 2-20

ISequentialStream interface, 2-20

LockType

tips for ADO programmers, 2-18

MDAC, 1-4

metadata columns

supported by Oracle Provider for OLE DB, A-13

Microsoft Data Access Components, 1-4

Microsoft Distributed Transaction Coordinator, 2-7

Microsoft Transaction Server, 2-7

MTS, see Microsoft Transaction Server

NDatatype, 2-9

object names

case, 2-20

OFA

Optimal Flexible Architecture, xx

OLE DB

consumers, 1-3

datatypes, A-2

design, 1-2

Microsoft web site, 1-4

overview, 1-2

providers, 1-3

Optimal Flexible Architecture (OFA), xx

Oracle

datatypes, A-2

Oracle base

described, xx

Oracle documentation

related guides, xxii

types of documents, xxi

Oracle home

described, xx

Oracle Provider for OLE DB

class ID, 2-2

features, 2-2

installation, 1-5

installed files, 1-5

intended audience, xviii

provider-specific information, A-1

system requirements, 1-4

Oracle Services for Microsoft Transaction Server, 1-4, 2-7

OraOLEDB

see Oracle Provider for OLE DB

OS authentication, 2-4

DBPROP_INIT_PROVIDERSTRING, 2-4

OSAuthent

connection string attribute for data source, 2-4

enabling OS authentication, 2-5

overview

OLE DB, 1-2

password expiration

connection string attribute, 2-5

PwdChgDlg, 2-5

PLSQLRSet, 2-8

connection string attribute for commands, 2-4, 2-10

properties

data source, A-3

data source info, A-3

initialization and authorization, A-5

rowset, A-6

rowset implications, A-10

sessions, A-6

supported by Oracle Provider for OLE DB, A-3

providers

OLE DB, 1-3

PwdChgDlg

connection string attribute for commands, 2-4

connection string attribute for data source, 2-5

registry

default attribute values, 2-4

returning rowsets

stored procedures and functions, 2-11

rowsets, 2-15

creating, 2-15

creating with ICommand, 2-15

creating with IOpenRowset, 2-15

date formats, 2-19

interfaces supported, A-12

properties, A-6

property implications, A-10

returning with procedures and functions, 2-11

schema, 2-19

searching with IRowsetFind, 2-17

updatability, 2-16

sample tables

building, 2-24

schema rowsets, 2-19

Server Data on Insert property, 2-17

sessions

interfaces supported, A-11

objects, 2-6

properties, A-6

SPPrmsLOB, 2-10

stored procedures and functions

executing, 2-7

returning rowsets, 2-11

system requirements

Oracle Provider for OLE DB, 1-4

tips

for ADO programmers, 2-18

tracing, A-14

transaction options

interfaces supported, A-13

transactions

distributed, 2-7

global, 2-7

isolation levels, 2-7

local, 2-7

types supported, 2-6

troubleshooting, vii, A-14

UCS-2 character set, 2-21

Unicode, 2-21