Oracle Ole Db Provider Download

Posted on by
Oracle Ole Db Provider Download Average ratng: 4,4/5 5267 reviews
  1. Oracle Ole Db Provider Download
  2. Download Oracle Provider For Ole Db 32 Bit
  3. Oracle Provider For Ole Db
  4. Oracle 12 Ole Db Provider Download

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

This chapter contains these topics:

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. 1.2 Overview of OraOLEDB Oracle Provider for OLE DB (OraOLEDB) is an OLE DB data provider that offers high performance and efficient access to Oracle data by OLE DB. Download OLE DB Driver. To install the OLE DB Driver for SQL Server you need the msoledbsql.msi installer. Run the installer and make your preferred selections. The OLE DB Driver for SQL Server can be installed side-by-side with earlier versions of Microsoft OLE DB providers. 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 following files are installed on the system. Some files have ver in their name to indicate the release version. The ODBC.NET Data Provider is an add-on component to the.NET Framework. It provides access to native ODBC drivers the same way the OLE DB.NET Data Provider provides access to native OLE DB.

1.1 Overview of OLE DB

OLE DB is an open standard data access methodology which utilizes a set of Component Object Model (COM) interfaces for accessing and manipulating different types of data. These interfaces are available from various database providers.

1.1.1 OLE DB Design

The design of OLE DB centers around the concept of a consumer and a provider. Figure 1-1 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


Description of 'Figure 1-1 OLE DB Flow'

OLE DB Data Providers

OLE DB data providers are a set of COM components that transfer data from a data source to a consumer. An 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.

1.2 Overview of OraOLEDB

Oracle Provider for OLE DB (OraOLEDB) is an OLE DB data provider that offers high performance and efficient access to Oracle data by OLE DB consumers.

In general, this developer's guide assumes that you are using OraOLEDB through OLE DB or ADO.

For sample code, the latest patches, and other technical information on the Oracle Provider for OLE DB, go to

Oracle Ole Db Provider Download

With the advent of the .NET framework, support has been provided for using the OLEDB.NET Data Provider with OraOLEDB. With the proper connection attribute setting, an OLEDB.NET Data Provider can utilize OraOLEDB to access Oracle Database.

See Also:

Download Oracle Provider For Ole Db 32 Bit

'OLEDB.NET Data Provider Compatibility' for further information on support for OLEDB.NET Data Provider

1.3 System Requirements

Oracle Provider For Ole Db

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

  • Windows Operating System:

    • 32-bit: Windows Vista (Business, Enterprise, and Ultimate Editions), Windows Server 2003, Windows Server 2003 R2, Windows 2000 or Windows XP Professional Edition.

    • 64 bit: Windows Vista x64 (Business, Enterprise, and Ultimate Editions), Windows Server 2003 x64, Windows Server 2003 R2 x64, or Windows XP x64.

    • 64-bit: Windows Server 2003 for Itanium-based systems.

  • Access to an Oracle Database (Oracle 9.2 or later)

  • Oracle Client release 11.1 or later and Oracle Net Services (included with Oracle Provider for OLE DB installation).

  • 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 release 11.1 or higher. This is required for consumers using Microsoft Transaction Server (MTS) or COM+.

1.4 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 Oracle Database Installation Guide for Windows

Oracle 12 Ole Db Provider Download

for installation instructions

During the installation process, the files listed in Table 1-1 are installed on the system. Some files have ver in their name to indicate the release version.

Table 1-1 Oracle Provider for OLE DB Files

FileDescriptionLocation

OraOLEDBver.dll

Oracle Provider for OLE DB

ORACLE_BASEORACLE_HOMEbin

OraOLEDBrfcver.dll

Oracle rowset file cache manager

ORACLE_BASEORACLE_HOMEbin

OraOLEDBrmcver.dll

Oracle rowset memory cache manager

ORACLE_BASEORACLE_HOMEbin

OraOLEDBrstver.dll

Oracle rowset

ORACLE_BASEORACLE_HOMEbin

OraOLEDBgmrver.dll

Oracle ODBC SQL parser

ORACLE_BASEORACLE_HOMEbin

OraOLEDBlangver.dll

where lang is the required language

Language-specific resource DLL

ORACLE_BASEORACLE_HOMEbin

OraOLEDBpusver.dll

Property descriptions

ORACLE_BASEORACLE_HOMEbin

OraOLEDButlver.dll

OraOLEDB utility DLL

ORACLE_BASEORACLE_HOMEbin

OraOLEDBver.tlb

OraOLEDB type library

ORACLE_BASEORACLE_HOMEbin

OraOLEDB.h

OraOLEDB header file

ORACLE_BASEORACLE_HOMEoledbinclude

OraOLEDBver.lib

OraOLEDB library file

ORACLE_BASEORACLE_HOMEoledblib

OraOLEDBlang.msb

where lang is the required language

Language-specific message file

ORACLE_BASEORACLE_HOMEoledbmesg

readme and documentation files

Release notes and online documentation

ORACLE_BASEORACLE_HOMEoledbdirectory

sample files

Sample code

ORACLE_BASEORACLE_HOMEoledbsamples


1.5 Component Certifications

Oracle provides support information for components on various platforms, lists compatible client and database versions, and identifies patches and workaround information.

Find the latest certification information at:

You must register online before using OracleMetaLink. After logging into OracleMetaLink, select Product Lifecycle from the left column. From the Products Lifecycle page, click Certifications. Other Product Lifecycle options include Product Availability, Desupport Notices, and Alerts.