Heteregenous connections client ==> oracle database ==> sqlserver
Date: Thu, 19 Jun 2008 05:28:00 -0700 (PDT)
Message-ID: <353d71dd-68f5-4e09-b96f-5b6afbfd21c5@d77g2000hsb.googlegroups.com>
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_at_rdt ...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 documentation 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
Received on Thu Jun 19 2008 - 07:28:00 CDT