Re: Heteregenous connections client ==> oracle database ==> sqlserver

On Jun 19, 8:28 am, chris.br..._at_providentinsurance.co.uk wrote:
> 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

What are the details for the database link: public vs private, current user or explicit user?

Only the tnsnames.ora file on the database server needs to have an entry for the remote database. The listener.ora and hs_init.ora would also only need to exist on the database server.

The question Shakespeare asked about the username in use and the request for information on the contents of the tnsnames.ora, listener.ora is also important.

HTH -- Mark D Powell -- Received on Thu Jun 19 2008 - 11:56:54 CDT