Oracle Provider for OLE DB Developer's Guide Release 9.0.1 for Windows Part Number A90171-01 |
|
This chapter introduces Oracle Provider for OLE DB (OraOLEDB).
This chapter contains these topics:
OLE DB is an open standard data access methodology which utilizes a set of COM interfaces for accessing and manipulating different types of data. These interfaces are available from various database providers.
Oracle Provider for OLE DB (OraOLEDB) offers high performance and efficient access to Oracle data by OLE DB consumers.
OLE DB's design centers around the concept of a consumer and provider. Figure 1-1, "OLE DB Flow" is an illustration of the OLE DB system. The consumer represents the traditional client. The provider places data into a tabular format and returns it to the consumer.
OLE DB data providers are a set of COM components that transfer data from a data source to a consumer. The OLE DB Provider places that data in a tabular format in response to calls from a consumer. Providers can be simple or complex. A provider may return a table, it may allow the consumer to determine the format of that table, and it may perform operations on the data.
Each provider implements a standard set of COM interfaces to handle requests from the consumer. A provider may implement optional COM interfaces to provide additional functionality.
With the standard interfaces, any OLE DB consumer can access data from any provider. Because of COM components, consumers can access them in any programming language that supports COM, such as C++, Visual Basic, and Java.
The OLE DB data consumer is any application or tool that utilizes OLE DB interfaces of a provider to access a broad range of data.
The following items are required on a system to use Oracle Provider for OLE DB:
www.microsoft.com/data/oledb/
Oracle Provider for OLE DB is included as part of your Oracle installation. It contains the features and demos that illustrate how to use this product to solve real-world problems.
During the installation process, the files listed in Table 1-1 are installed on the system.
|
Copyright © 1996-2001, Oracle Corporation. All Rights Reserved. |
|