locked
Linked Server error RRS feed

  • Question

  • Hi,

    I have configured linked server for Oracle. The linked server is fine and I am able to test the connection to succeed, also able to drill down all Tableds and Views from the Linked server

    I have also checked 'Allow Inprocess' for the Ora.OLEDB.Oracle provider


    But when I execute an OPEN QUERY,

    Select * from
    openquery (CISL,'SELECT * FROM Tab1
    group by Col1 ORDER BY Col2 ')

    I get the below error
    Msg 7399, Level 16, State 1, Line 1
    The OLE DB provider "OraOLEDB.Oracle" for linked server "CISL" reported an error. Access denied.
    Msg 7350, Level 16, State 2, Line 1
    Cannot get the column information from OLE DB provider "OraOLEDB.Oracle" for linked server "CISL".


    The below openquery does work, and is able to retrieve data.
    Select * from
    openquery (CISL,'SELECT * FROM Tab1)


    What is wrong with the first query. This works on another server with SQL Server 2005


    Thanks,

    Wednesday, August 13, 2014 12:36 PM

Answers

  • Thanks all this is solved.

    Just in the Server Options of the Linked server I had to set the RPC value to  TRUE

    • Marked as answer by Elvis Long Monday, August 18, 2014 8:06 AM
    Wednesday, August 13, 2014 12:41 PM

All replies

  • Thanks all this is solved.

    Just in the Server Options of the Linked server I had to set the RPC value to  TRUE

    • Marked as answer by Elvis Long Monday, August 18, 2014 8:06 AM
    Wednesday, August 13, 2014 12:41 PM
  • Hi Sudhakar,

    Thanks for share your solution to deal with this issue. It will benefit for other community members who have a similar issue with you.

    Regards,


    Elvis Long
    TechNet Community Support

    Monday, August 18, 2014 8:07 AM