We installed the 11.2.0.3.0 client runtime on Windows 7 32 bit (which installs 'Oracle Provider for OLE DB 11.2.0.3.0' by default) and were still. I am trying to add a linked Oracle Server to our MSSQL 2005 server but am missing the OraOLEDB.Oracle Provider under Server Objects -> Linked Servers -> Providers in the Object Explorer. Also I have considered using a simple OPENROWSET command to attach to the Oracle Instance but unfortunately one of the parameters required is the.
1 Introduction to Oracle Provider for OLE DB This chapter introduces Oracle Provider for OLE DB (OraOLEDB). This chapter contains these topics:. Overview of OLE DB OLE DB is an open standard data access methodology which utilizes a set of interfaces for accessing and manipulating different types of data. These interfaces are available from various database providers. OLE DB Design OLE DB's design centers around the concept of a and.
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 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. 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 With the advent of the.NET framework, support has been provided for using the OLE DB.NET Data Provider with OraOLEDB. With the proper connection attribute setting, an OLE DB.NET Data Provider can utilize OraOLEDB to access Oracle.
See Also: for further information on support for OLE DB.NET Data Provider System Requirements The following items are required on a system to use Oracle Provider for OLE DB:. Windows 98, Windows NT 4.0, Windows 2000, or Windows XP.
Access to an Oracle Server (release 8 or later). 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 9.0). This item is required for consumers using Microsoft Transaction Server (MTS) or COM+. See Also: The for installation instructions During the installation process, the files listed in are installed on the system.