November 16, 2011 at 2:36 am
Getting Error while creating Linkedserver to ORACLE.
OraOLEDB.Oracle" for linked server "LINKORATEST" returned message "ORA-12557: TNS:protocol adapter not loadable". (Microsoft SQL Server, Error: 7303)
can you help me how to create the linked server to oracle.
November 16, 2011 at 2:51 am
Does the OCI connect outside SQLServer? You can check that with TNSPING.
If the connection is not successful in Oracle Client, it can't succeed in SQLServer.
-- Gianluca Sartori
November 16, 2011 at 4:14 am
Gianluca Sartori (11/16/2011)
Does the OCI connect outside SQLServer? You can check that with TNSPING.If the connection is not successful in Oracle Client, it can't succeed in SQLServer.
It's not a common error in Oracle. It's adaptor issue. For more, check Oracle Forums.
ORA-12557: TNS:protocol adapter not loadable
Cause: On some platforms (such as OS/2) protocol adapters are loaded at run-time. If the shared library (or DLL) for the protocol adapter is missing or one of its supporting libraries is missing then this error is returned.
Action: For further details, turn on tracing and reexecute the operation. The trace file will include the name of the shared library (or DLL) that could not be loaded.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply