Oracle Provider for OLE DB User's Guide
Release 8.1.6

A75235-01

Library

Product

Contents

Prev

Index

A  C  D  E  F  G  H  I  L  M  O  P  R  S  T 


A

ActiveX Data Objects, xviii
attributes
connection string, 2-3

C

CacheType
connection string attribute for rowsets, 2-3, 2-14
ChunkSize
connection string attribute for rowsets, 2-4, 2-14
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
interfaces supported, A-12
object, 2-8
parameters, 2-8
preparing, 2-8
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
data source, 2-4
defaults, 2-4
registry, 2-4
rowsets, 2-14
consumers
OLE DB, 1-3
conventions used in this guide, xix
creating
an instance of the data source object, 2-2
rowsets, 2-12
Cursor Stability, 2-7
CursorType
tips for ADO programmers, 2-15
custom error objects
interfaces supported, A-13
Customer Support
contacting, vii

D

data source
creating an instance of, 2-2
interfaces supported, A-11
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-16
settings, 2-16
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-6
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-5
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, 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-7
DBPROP_LOCKMODE property, A-7
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-13, 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
design
OLE DB, 1-2
distributed transactions, 2-7
documentation
generic, xxi

E

error messages
resolving, vii
errors
HRESULT, 2-17
OLE and COM, 2-17
examples
connecting to an Oracle database using ADO, 2-5
stored procedure returning result set, 2-10
using OraOLEDB with Visual Basic, 2-18

F

features
Oracle Provider for OLE DB, 2-2
FetchSize
connection string attribute for rowsets, 2-3, 2-14
files
installed on system for Oracle Provider for OLE DB, 1-4
Oracle Provider for OLE DB, 1-4

G

global transactions, 2-7

H

HRESULT
error return code, 2-17

I

initialization and authorization
properties, A-5
installation
files for Oracle Provider for OLE DB, 1-4
Oracle Provider for OLE DB, 1-4
interfaces
commands, A-12
custom error objects, A-13
data source, A-11
rowsets, A-12
sessions, A-11
supported by Oracle Provider for OLE DB, A-11
transaction options, A-12

L

LOB support, 2-17
ISequentialStream interface, 2-17
LockType
tips for ADO programmers, 2-15

M

MDAC, 1-3
metadata columns
supported by Oracle Provider for OLE DB, A-13
Microsoft Data Access Components, 1-3
Microsoft Distributed Transaction Coordinator, 2-7
Microsoft Transaction Server, 2-7
MTS, see Microsoft Transaction Server

O

OFA
Optimal Flexible Architecture, xx
OLE DB
consumers, 1-3
datatypes, A-2
design, 1-2
Microsoft web site, 1-3
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-4
installed files, 1-4
intended audience, xviii
provider-specific information, A-1
system requirements, 1-3
Oracle Services for Microsoft Transaction Server, 1-3, 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

P

password expiration
connection string attribute, 2-6
PwdChgDlg, 2-6
PLSQLRSet
connection string attribute for commands, 2-4, 2-8
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-6

R

registry
default attribute values, 2-4
returning rowsets
stored procedures and functions, 2-9
rowsets, 2-12
creating, 2-12
creating with ICommand, 2-12
creating with IOpenRowset, 2-12
date formats, 2-16
interfaces supported, A-12
properties, A-6
property implications, A-10
returning with procedures and functions, 2-9
schema, 2-15
searching with IRowsetFind, 2-14
updatability, 2-13

S

sample tables
building, 2-18
schema rowsets, 2-15
Server Data on Insert property, 2-13
sessions
interfaces supported, A-11
objects, 2-6
properties, A-6
stored procedures and functions
executing, 2-8
returning rowsets, 2-9
system requirements
Oracle Provider for OLE DB, 1-3

T

tips
for ADO programmers, 2-15
transaction options
interfaces supported, A-12
transactions
distributed, 2-7
global, 2-7
isolation levels, 2-7
local, 2-7
types supported, 2-7
troubleshooting, vii

Prev
Oracle
Copyright © 2000 Oracle Corporation.

All Rights Reserved.

Library

Product

Contents