Re: Oracle7 Networking Question

Dave,

 The only way you can connect to another database without specifying a connect string is if you set the LOCAL environment variable on the client. Set the LOCAL variable to the connect string of the other database your want to connect to.

Hope this help.

Roy Klassen rklassen_at_pei.sympatico.ca

Dave Wilga <dwilga_at_erols.com> wrote in article <33a8c41a.10745991_at_news.erols.com>...
> Configuration:
> Oracle 7.3 NT (single instance) Installed and accessible from both
> the server it is installed on, as well as client machines through
> SQL*Net.
>
> Question:
> Is there a configuration option to allow CLIENT machines to access a
> database on another machine WITHOUT specifying the Host String in the
> logon? ie.. SCOTT/TIGER and not SCOTT/TIGER_at_SERVER
>
> My default installation allows this when logging in while at the
> server machine, but not the clients. I figure it may have something
> to do with LISTERNER.ORA and/or TNSNAMES.ORA but this particular
> concept is subtly hidden in the manuals. Any help appreciated.
>
>
>
Received on Wed Jun 18 1997 - 00:00:00 CDT