Post reply

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

  • July 12, 2013 at 8:41 am

    #277411

    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',

    'password'

    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.

  • July 12, 2013 at 8:44 am

    #1631986

    Tried Googling it?

  • July 12, 2013 at 10:02 am

    #1632033

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

  • July 14, 2013 at 9:52 pm

    #1632279

    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

  • July 15, 2013 at 12:57 am

    #1632312

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

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP

  • July 15, 2013 at 1:53 am

    #1632344

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

  • June 15, 2014 at 12:26 pm

    #1721799

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

    Did you reboot?

  • December 12, 2014 at 1:58 am

    #1764299

    Hi,

    To register provider you need one more oracle product instantclient-sqlplus-win-x86-64-11.2.0.1.0.zip and make some changes in register. All details are described in this article. http://nampark.wordpress.com/2011/01/20/installing-64-bit-odac-11-2-to-microsoft-sql-server-2008-r2-x64-for-replication/

    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.

  • July 3, 2018 at 8:24 am

    #1996159

    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.

    -

  • May 28, 2019 at 7:05 am

    #3647727

    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