Cannot create an instance of OLE DB provider "OraOLEDB.Oracle" Using linked server

Posted on 2011-10-25
Last Modified: 2012-05-12
Hi Experts

I am creating a linked server to SQL 2008 64bit to an Oracle DB,  I have installed the Oracle 64bit instant client (11.2) and can connect to the Oracle DB using A system DSN, I have installed the Oracle Data access components and in SQL server have st the to allow inprocess, however when I create a linked Server I get the error message

Cannot create an instance of OLE DB provider "OraOLEDB.Oracle" for linked server "RIMS_TRS"

Im thinking that some environment variable isnt set or the dll isnt correctly registered but im cluting at straws at the moment.
Question by:MrDavidThorn
    1 Comment
    LVL 17

    Accepted Solution


    Featured Post

    Looking for New Ways to Advertise?

    Engage with tech pros in our community with native advertising, as a Vendor Expert, and more.

    Join & Write a Comment

    This post first appeared at Oracleinaction  ( Anju Garg (Myself). I  will demonstrate that undo for DML’s is stored both in undo tablespace and online redo logs. Then, we will analyze the reaso…
    This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
    This video explains at a high level about the four available data types in Oracle and how dates can be manipulated by the user to get data into and out of the database.
    Video by: Steve
    Using examples as well as descriptions, step through each of the common simple join types, explaining differences in syntax, differences in expected outputs and showing how the queries run along with the actual outputs based upon a simple set of dem…

    734 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    22 Experts available now in Live!

    Get 1:1 Help Now