Oracle Ole Db Provider Download

  1. This example shows the download of OLE DB Provider for DB2 Version 5. To Install the Product: Go to the Microsoft Download Center. Download either the x86 (32-bit) or the x64 (64-bit) version of DB2OLEDB5x64.msi installation program. To install the OLE DB Driver for SQL Server you need the msoledbsql.msi installer.
  2. Oracle Database Extensions for.NET - available in 12.2 and earlier for upgrade only Oracle Provider for OLE DB Oracle OLAP Provider for OLE DB - 18c and higher.

Download 32 and 64-bit clients from (click 'see all' to see different versions, otherwise, you'll be downloading the complete Oracle program. Your downloads should.

Oracle Provider for OLE DB Developer's Guide
Release 9.0.1 for Windows

Part Number A90171-01

Home

Book List

Contents

Index

Master Index

Feedback

This chapter introduces Oracle Provider for OLE DB (OraOLEDB).

This chapter contains these topics:

  • Overview of OLE DB
  • System Requirements
  • OraOLEDB Installation

Overview of OLE DB

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 Design

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.

Figure 1-1 OLE DB Flow


Text description of the illustration oop81002.gif
OLE DB Data Providers
Oracle

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.

OLE DB Data Consumers

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.

System Requirements

The following items are required on a system to use Oracle Provider for OLE DB:

Oracle Ole Db Provider Download Manager

  • Windows 95, 98, 2000, or Windows NT 4.0
  • Access to an Oracle Server (release 8 or later)
  • Oracle Net Services
  • Redistributable files provided with Microsoft Data Access Components (MDAC) 2.1 or higher are required by the provider. These files are available at the Microsoft Web site:
  • Oracle Services for Microsoft Transaction Server (version 9.0 Beta or later). This item is required for consumers using Microsoft Transaction Server (MTS) or COM+.

    Note:

    With the Oracle Services for Microsoft Transaction Server installed, OraOLEDB supports MTS against database versions Oracle9i Release 1 (9.0.1), Oracle8i (8.1.5 or higher) and Oracle8 (8.0.6 or higher).

OraOLEDB Installation

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.

See Also:

The Oracle9i Database installation guide for Windowsfor installation instructions

During the installation process, the files listed in Table 1-1 are installed on the system.

Table 1-1 Oracle Provider for OLE DB Files
FileDescriptionLocation

OraOLEDB.dll

Oracle Provider for OLE DB

ORACLE_BASEORACLE_HOMEbin

OraOLEDBrfc.dll

Oracle rowset file cache manager

ORACLE_BASEORACLE_HOMEbin

OraOLEDBrmc.dll

Oracle rowset memory cache manager

ORACLE_BASEORACLE_HOMEbin

OraOLEDBrst.dll

Oracle rowset

ORACLE_BASEORACLE_HOMEbin

OraOLEDBgmr.dll

Oracle ODBC SQL parser

ORACLE_BASEORACLE_HOMEbin

OraOLEDBlang.dll

Language-specific resource DLL

ORACLE_BASEORACLE_HOMEbin

OraOLEDBpus.dll

Property descriptions

ORACLE_BASEORACLE_HOMEbin

OraOLEDButl.dll

OraOLEDB utility DLL

ORACLE_BASEORACLE_HOMEbin

OraOLEDB.tlb

OraOLEDB type library

ORACLE_BASEORACLE_HOMEbin

OraOLEDB.h

OraOLEDB header file

ORACLE_BASEORACLE_HOMEoledbinclude

OraOLEDB.lib

OraOLEDB library file

ORACLE_BASEORACLE_HOMEoledblib

OraOLEDBlang.msb

Language-specific message file

ORACLE_BASEORACLE_HOMEoledbmesg

readme and documentation files

Release notes and online documentation

ORACLE_BASEORACLE_HOMEoledbdoc

sample files

Sample code

ORACLE_BASEORACLE_HOMEoledbsamples

Oracle Ole Db Client


Copyright © 1996-2001, Oracle Corporation.
All Rights Reserved.

Home

Book List

Contents

Index

Master Index

Feedback