Re: I do not want to use TNSNAMES.ORA. How ?

From: Fredrik Larsson <no_spam_mail2fred_at_hotmail.com>
Date: 1998/01/04
Message-ID: <01bd18b2$7bf45f60$28282828@maestro>#1/1

We have one application at work that uses the SQL*NET that is installed on the server.
Windows.ini is modified to point toward the server. One of the *.ora files are installed locally (don't remember if it is sqlnet.ora, tnsnames.ora or both...)

And that application manages without a local install. If I am not mistaken this means that it uses SQL*NET over the network which means slower respone times and heavier network traffic. WHICH IS NOT DESIRABLE!!!

If you are thinking that your database server is to be moved between different servers then the solution is to use a DNS name instead of a TCP/IP address. Then when the database location is changed simply alter the chosen DNS name to point at the new TCP/IP address. This is done at the Domain Name Server that either you have or your ISP.

> > > Is there a way I can connect to a remote database without using alias
name
> > > -
> > > I mean specify the exact location of the database.
> >
Received on Sun Jan 04 1998 - 00:00:00 CST