Skip Headers

Oracle Provider for OLE DB Developer's Guide
Release 9.2

Part Number A95498-01
Go To Documentation Library
Home
Go To Product List
Book List
Go To Table Of Contents
Contents

Master Index

Feedback

Go to previous page

Index

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


A

ActiveX Data Objects, x
ADO, 2-5, 2-14
ADO.NET, 2-24
attributes
connection string, 2-3

C

C#
connection string, 2-25
example, 2-25
CacheType
connection string attribute for rowsets, 2-3, 2-18
case of object names, 2-21
ChunkSize
connection string attribute for rowsets, 2-3, 2-19
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, x
commands
object, 2-8
parameters, 2-8
preparing, 2-8
Component Object Model (COM), x
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-18
consumers
OLE DB, 1-3
creating
an instance of the data source object, 2-2
rowsets, 2-16
Cursor Stability, 2-7
CursorType
tips for ADO programmers, 2-19
custom error objects
interfaces supported, A-13

D

data source
creating an instance of, 2-2
distributed transactions, 2-4
objects, 2-2
properties, A-3
data source info
properties, A-3
DataTable, 2-26
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-20
settings, 2-20
DBPROP_AUTH_PASSWORD property
setting, 2-3
DBPROP_AUTH_USERNAME property
enabling OS authentication, 2-5
setting, 2-3
DBPROP_INIT_DATASOURCE property
setting, 2-3
DBPROP_INIT_PROMPT property
setting, 2-3
DBPROP_INIT_PROVIDERSTRING property
enabling OS authentication, 2-5
setting, 2-4
DBPROP_IROWSETUPDATE property
setting of other properties, A-10
DBPROP_SERVERDATAONINSERT property, 2-18
DBPROPSET_DBINIT property set
setting properties, 2-3, 2-4
debugging, A-14
demobld.sql, 2-27
design
OLE DB, 1-2
DistribTX
connection string attribute for commands, 2-3
Distributed Transactions, 2-4
distributed transactions, 2-7

E

enlistment
distributed transactions, 2-4
errors
HRESULT, 2-23
OLE and COM, 2-23
examples, 2-24, 2-25
connecting to an Oracle database using ADO, 2-5
stored procedure returning multiple rowsets, 2-13
using OraOLEDB with Visual Basic, 2-27

F

features
Oracle Provider for OLE DB, 2-2
features, new, xix
FetchSize
connection string attribute for rowsets, 2-4, 2-19
files
installed on system for Oracle Provider for OLE DB, 1-5
Oracle Provider for OLE DB, 1-5

G

global transactions, 2-7

H

HRESULT
error return code, 2-23

I

initialization and authorization
properties, A-5
installation, 1-5
files for Oracle Provider for OLE DB, 1-5
Oracle COM Automation, 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

L

LOB support, 2-21
ISequentialStream interface, 2-21
LockType
tips for ADO programmers, 2-19

M

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

N

NDatatype, 2-10
.NET, 2-24
new features, xix

O

object names
case, 2-21
OLE DB
consumers, 1-3
datatypes, A-2
design, 1-2
Microsoft web site, 1-4
providers, 1-3
OLE DB .NET Data Provider, 2-4
Compatibility, 2-24
compatibility, 2-24
OleDbDataAdapter.Update(), 2-26
OLEDB.NET, 2-4, 2-24
Oracle
datatypes, A-2
Oracle COM Automation
installing, 1-5
Oracle Provider for OLE DB
class ID, 2-2
features, 2-2
intended audience, x
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
OraOLEDB sessions, 2-6
OS authentication, 2-4
DBPROP_INIT_PROVIDERSTRING, 2-4
OSAuthent
connection string attribute for data source, 2-4
enabling OS authentication, 2-5

P

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

R

registry
default attribute values, 2-4
returning rowsets
stored procedures and functions, 2-12
ROWID, 2-26
rowsets, 2-16
creating, 2-16
creating with ICommand, 2-16
creating with IOpenRowset, 2-16
date formats, 2-20
interfaces supported, A-12
properties, A-6
property implications, A-10
returning with procedures and functions, 2-12
schema, 2-20
searching with IRowsetFind, 2-18
updatability, 2-17

S

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

T

tips
for ADO programmers, 2-19
TraceCategory, A-15
TraceFileName, A-14
TraceLevel, A-15
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-7

U

UCS-2 character set, 2-22
Unicode, 2-22

V

VB.NET
connection string, 2-24
examples, 2-24

Go to previous page
Oracle
Copyright © 1999, 2002 Oracle Corporation.

All Rights Reserved.
Go To Documentation Library
Home
Go To Product List
Book List
Go To Table Of Contents
Contents

Master Index

Feedback