Post reply

Oracle provider not found

  • December 14, 2010 at 8:03 am

    #244321

    Hi friends,

    I'm creating Linked server to Oracle. I installed Oracle client 10g and set up ODBC connection(Oracleserver) to Oracle database.I executed the following to create the linked server..

    EXEC sp_addlinkedserver

    'OracleLinkedServer', 'Oracle',

    'ORAOLEDB.ORACLE', 'Oraclelinkedserver'

    EXEC sp_addlinkedsrvlogin

    'OracleLinkedServer', false,

    'ars\user1', 'ouser1',

    'ouser1pwd'

    When I do a select on Oracle table I get the below error:

    SELECT * FROM

    OracleLinkedServer..ouser1.table1

    OraOLEDBpus10.dll: The specified module could not be found.

    Any help is appreciated.. Thanks

  • December 14, 2010 at 10:24 am

    #1262352

    I restarted the db server and ran the select statement again.. I get a different error now

    SELECT * FROM

    OracleLinkedServer..ouser1.table1

    OLE DB provider "ORAOLEDB.ORACLE" for linked server "Linkedservertest" returned message "ORA-12154: TNS:could not resolve the connect identifier specified".

    Msg 7303, Level 16, State 1, Line 2

    Cannot initialize the data source object of OLE DB provider "ORAOLEDB.ORACLE" for linked server "OracleLinkedServer".

    I'm able to connect to the Oracle database using the SQL*plus Oracle client and also the ODBC connection to the database is successful.. Please help

    Thanks

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

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