Results 1 to 2 of 2
  1. #1
    Join Date
    Jan 2006

    Unanswered: Problem adding linked server to Oracle

    I am attempting to add a linked server to ORACLE from SQL Server. I am able to get the linked server to work using the MS OLE DB Provider for Oracle , however I would rather use the Oracle Provider for OLE DB. When I set the linked server to use the Oracle provider I get the following error when issueing a query.

    Could not execute query against OLE DB provider 'OraOLEDB.Oracle'.
    OLE DB error trace [OLE/DB Provider 'OraOLEDB.Oracle' ICommandText::Execute returned 0x80040155].

    The query I attempt is

    select * from openquery(oracle_test,'select count(*) from employee')emp

    Does anyone have a suggestion on a solution?

  2. #2
    Join Date
    Dec 2002
    I'd like to help but for some reason, the Oracle Provider for OLE DB is not an option on my server. I am using Oracle client.

    Can you turn on client-side tracing in your sqlnet.ora file? E.g.:

    # Uncomment the following lines in order to start a client level trace
    # trace_level_client = 16
    # trace_file_client = client
    # trace_directory_client = c:\temp

    Be sure to remove the tracing after you are through.

    Beyond that, what about verifying the options on the Server Options tab of the linked server (RPC, RPC Out and Data Access). Finally, be sure to verify the user name/password and/or context of the user being passed to Oracle.


    Have you hugged your backup today?

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts