I am using 9i client to connect a 9i database 9.2.0.5 enterprise / 9i
listener
I have setup an ODBC connection to a sqlserver database on this server
I can run the following code on the server
select * from mi_v_agents@[EMAIL PROTECTED]
...where rdt is a link
whenever I try and run from my client it fails / ORA-12154
I am a bit confused as I can use the listener to connect to 9i
oracle / but obviously not to the sqlserver database via the link .. I
am thinking it is related to tnsnames files being used but I would
have thought that I would be just using config on the server once I'd
connected to the 9i database.
From the do***entation I've put what I thought were the correct
entries in tnsnames.ora/listener.ora
and in \hs\admin\initfile on the server
Any suggestions on methods of diagnozing\tracing where I am failing
would be appreciated
cheers
Chris B
