Re: Which SQL*Net version to use?
Date: 1996/05/02
Message-ID: <3188B9FE.4DB0_at_us1j69.glaxo.com>#1/1
Petri Riipinen wrote:
>
> Hi there.
>
> In the Oracle WG Server 7.1 for NW there are two
> version of SQL*Net: 1.1 and 2.1 (if my memory serves
> me right...).
> According to Oracle the version 1.1 is going away and will no longer be
supported by Oracle, starting in June if I remember correctly. Version
2.1 is supposed to be a much better product. We are using 2.1 now. You
can set up a tsnames.ora file that has all the connect information for
any and all Oracle connections with an alias. To connect your connect
string is just that alias that uses the tsnames.ora file to get the
needed string. Instead of a connect string like "_at_t:152.59.2.1:prd14" it
would be "prd14" for the connect string. Also in the client server world
when you lost a connection or a client's computer froze and they
re-booted in 1.1 the SQL*Net connection was still there and it was hard
to get rid of. In 2.1 that is supposed to be fixed, if you lose the
connection or freezes, then it drops the SQL*Net connection.
John Jones
Oracle Consultant
jmj22026A_at_us1j69.glaxo.com
Received on Thu May 02 1996 - 00:00:00 CEST