Em wrote:Just to understand your setup, before trying to fix anything -
HOWEVER, I have SSMS 2008 installed on MY PC. This PC can also (independent of SQL) access the same Oracle database - I have client software set up on it. But when I try to access the Linked Server, remotely, from my PC, using SSMS 2008, I get errors:
OLE DB provider "OraOLEDB.Oracle" for linked server "eplive" returned message "ORA-12154: TNS:could not resolve the connect identifier specified".12154 means that, using configured naming methods, the connect id (aka. tns alias) could not be resolved to a connect descriptor i.e. address parameters to be used in next step of connection.
Msg 7303, Level 16, State 1, Line 1
Cannot initialize the data source object of OLE DB provider "OraOLEDB.Oracle" for linked server "eplive".
I can tnsping the database just fine from my PC.In this case, tnsping from the Win 2003 instead. That's where Linked server does the lookup.
orafad wrote:I have SSMS 2008 as a client tool on my pc. I have SSMS 2005 on the server on which my 2005 SQL databases (and the link to my Oracle Linked Server).
Just to understand your setup, before trying to fix anything -
So you've only got SSMS, as a client tool to access and manage the 2005 Server on Win 2003, on your PC. Not a second MS Sql Database service, right?
In that case, you don't need the Oracle client software on that pc, in a Linked server context. You'd only need it on the MS Sql (2005) host.
How are you accesing the Linked server from SSMS 2008? First connected to the remote 2005 db engine?
Where is the Oracle server running? On a third machine?
To simplify, you could try entering <hostname>:<port>/<servicename> (fill in Oracle related details) for Data source in the Linked server properties.I don't know the port #!
In this case, tnsping from the Win 2003 instead. That's where Linked server does the lookup.There is NO tnsping installed, apparently, with Oracle 11g client? I cannot find tnsping.exe on that server. The client is there, my entries pointing to my TNS_ADMIN are in my registry...