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

  • Hello

    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.

  • Tried Googling it?

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

  • 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

  • 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

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

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

    Did you reboot?

  • Hi,

    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.

  • 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.


  • 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 9 (of 9 total)

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