This chapter introduces Oracle Provider for OLE DB (OraOLEDB).
- Download Ole Db Provider For Odbc Driver
- Microsoft Ole Db Provider For Sql Server Error
- Microsoft Ole Db Provider Download
- Oracle Ole Db Download
- Microsoft Ole Db Provider For Oracle Download
- Microsoft Ole Db Provider For Oracle Error
How to set up and troubleshoot a linked server to an Oracle database in SQL Server. Microsoft only supports Microsoft OLE DB Provider for Oracle and Microsoft ODBC Driver for Oracle. If you use a third-party provider or a third-party driver to connect to Oracle, you must contact the respective vendor for any problems that you may.
This chapter contains these topics:
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.
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
Download Ole Db Provider For Odbc Driver
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.
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.
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:
'OLEDB.NET Data Provider Compatibility' for further information on support for OLEDB.NET Data ProviderSystem Requirements
The following items are required on a system to use Oracle Provider for OLE DB:
- Windows Operating System:
- 32-bit: Windows 7 (Professional, Enterprise, and Ultimate Editions), Windows Vista (Business, Enterprise, and Ultimate Editions), Windows Server 2008 (Standard, Enterprise, Datacenter, Web, and Foundation Editions), Windows Server 2003 R2 (all editions), Windows Server 2003 (all editions), or Windows XP Professional Edition.Oracle supports 32-bit Oracle Provider for OLE DB on x86, AMD64, and Intel EM64T processors on these operating systems.
- x64: Windows 7 x64 (Professional, Enterprise, and Ultimate Editions), Windows Vista x64 (Business, Enterprise, and Ultimate Editions), Windows Server 2008 R2 x64 (Standard, Enterprise, Datacenter, Web, and Foundation Editions), Windows Server 2008 x64 (Standard, Enterprise, Datacenter, Web, and Foundation Editions), Windows Server 2003 x64 (all editions), Windows Server 2003 R2 x64 (all editions), or Windows XP x64.Oracle supports 32-bit Oracle Provider for OLE DB and 64-bit Oracle Provider for OLE DB for Windows x64 on these operating systems.
- Access to an Oracle Database (Oracle 9.2 or later)
- Oracle Client 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.2 or higher. This is required for consumers using Microsoft Transaction Server (MTS) or COM+.
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.
Microsoft Ole Db Provider For Sql Server Error
See Also:
The Oracle Database Installation Guide for Windows for installation instructionsDuring 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
Dell smartcard keyboard driver windows 7 64 bit. Now I do recall to notice that we have enabled for automatic Windows Update but the others sub options disabled. Question might be, if they are not stage? Or down load them to the stored directory so they could be pickup by PnP.
File | Description | Location |
---|---|---|
OraOLEDB ver .dll | Oracle Provider for OLE DB | ORACLE_BASEORACLE_HOME bin |
OraOLEDBrfc ver .dll | Oracle rowset file cache manager | ORACLE_BASEORACLE_HOME bin |
OraOLEDBrmc ver .dll | Oracle rowset memory cache manager | ORACLE_BASEORACLE_HOME bin |
OraOLEDBrst ver .dll | Oracle rowset | ORACLE_BASEORACLE_HOME bin |
OraOLEDBgmr ver .dll | Oracle ODBC SQL parser | ORACLE_BASEORACLE_HOME bin |
OraOLEDB lang ver .dll where lang is the required language | Language-specific resource DLL | ORACLE_BASEORACLE_HOME bin |
OraOLEDBpus ver .dll | Property descriptions | ORACLE_BASEORACLE_HOME bin |
OraOLEDButl ver .dll | OraOLEDB utility DLL | ORACLE_BASEORACLE_HOME bin |
OraOLEDB ver .tlb | OraOLEDB type library | ORACLE_BASEORACLE_HOME bin |
OraOLEDB.h | OraOLEDB header file | ORACLE_BASEORACLE_HOME oledbinclude |
OraOLEDB ver .lib | OraOLEDB library file | ORACLE_BASEORACLE_HOME oledblib |
OraOLEDB lang .msb where lang is the required language | Language-specific message file | ORACLE_BASEORACLE_HOME oledbmesg |
readme and documentation files | Release notes and online documentation | ORACLE_BASEORACLE_HOME oledbdirectory |
sample files | Sample code | ORACLE_BASEORACLE_HOME oledbsamples |
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 My Oracle Support (formerly OracleMetaLink):
Microsoft Ole Db Provider Download
You must register online before using My Oracle Support. After logging into My Oracle Support, 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.
Viewed 831 times
Oracle Ole Db Download
Its gives me an Oracle Error 'Microsoft OLE DB Provider for Oracle error '80040e14' ORA-00936: missing expression.On line no 49. (set Rec=objCmd.Execute) may be something wrong with the sql statement..tHIS Was basically done to prevent sql injection
Microsoft Ole Db Provider For Oracle Download
Ankit BansalAnkit Bansal
Is this question similar to what you get asked at work? Learn more about asking and sharing private information with your coworkers using Stack Overflow for Teams.