01-26-06, 12:52 #1Registered User
- 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?
01-27-06, 13:10 #2Registered User
- 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 126.96.36.199 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.
hmscottHave you hugged your backup today?