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

  • tnnelzo

    Mr or Mrs. 500

    Points: 531

    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.

  • Cowboy DBA

    SSCrazy

    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: 29186

    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: 258826

    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

  • tnnelzo

    Mr or Mrs. 500

    Points: 531

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

  • Jo Pattyn

    SSC-Dedicated

    Points: 31255

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

    Did you reboot?

  • AlexMcCo

    SSCrazy

    Points: 2440

    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.

  • Jason-

    SSCrazy

    Points: 2495

    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.

    -

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

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