The OLE DB provider "OraOLEDB.Oracle" has not been registered.

  • tnnelzo

    Mr or Mrs. 500

    Points: 531


    I would like to connect oracle database to sql server 2005 and i installed oracle client and also used the following queries to create a linked server

    1.sp_addlinkedserver 'AGRICULTS', 'Oracle',

    'OraOLEDB.Oracle', 'BILLSTBLS'

    2.sp_addlinkedsrvlogin 'AGRICULTS', false, NULL, 'user',


    The linked server is created but when i try to run my query in sql server 2005 i get the following error:

    The OLE DB provider "OraOLEDB.Oracle" has not been registered.

    please help on this issue. Thanks.

  • Cowboy DBA


    Points: 2135

    Tried Googling it?

  • tnnelzo

    Mr or Mrs. 500

    Points: 531

    Yes i have been googled it several times but all in vain. ...thanks.

  • happycat59

    One Orange Chip

    Points: 29189

    Where did you install the Oracle client software ? For it to used as a linked server, it will need to be installed onto the Windows server that you have the SQL Server database engine installed on

  • Koen Verbeeck

    SSC Guru

    Points: 258955

    Maybe you installed the 32-bit client while SQL Server is 64-bit?

    Need an answer? No, you need a question
    My blog at
    MCSE Business Intelligence - Microsoft Data Platform MVP

  • tnnelzo

    Mr or Mrs. 500

    Points: 531

    I installed the Oracle client on the same drive where SQL Server is installed.

  • Jo Pattyn


    Points: 31335

    As Koen mentioned, did you install the 64-bit variant of the oracle client?

    Did you reboot?

  • AlexMcCo


    Points: 2644


    To register provider you need one more oracle product and make some changes in register. All details are described in this article.

    Hope it helps. (I used this article to create oracle linked server to SQL 2014, Oracle version is 11)

    ~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*Brevity is the soul of wit.

  • Jason-


    Points: 2536

    Cowboy DBA - Friday, July 12, 2013 8:44 AM

    Tried Googling it?

    Yes, that's what I'm doing right now.  Your response from 5 years ago is as useless and rude now it was then.


  • mohamed.gad 51696


    Points: 1

    Hey mate! Hope you found the solution. If you did, would you be able to share the love on this thread please?

    Many thanks!

Viewing 10 posts - 1 through 10 (of 10 total)

You must be logged in to reply to this topic. Login to reply