Re: SQL*Net V2 vs SQL*Net V1

1. Support of different protocols like DECnet, IPX/SPX, ...
2. Multi-protocol interchanger (you can have your host using TCP/IP and your clients using Netware as long as you have one box connected to both subnets. This box will translate back and forth.
3. Names service. You do not have to specify a huge tnsnames.ora.
4. Multithreaded server. It is not possible with V1
5. 32-bit drivers (client side)
6. Desupport of V1 by Oracle
7. Encryption and security features are supported.
8. (I'm out of new ideas. Please fill in...)

One big disadvantage should be mentioned: it is far easier to remember the V1 connect strings because they would always represent in V1 the protocol (either TCP/IP or IPC), the target server and the instance name.

Martin Haltmayer

Mike Streeton wrote:
>
> Can somebody please remind me what the advantages to using SQL*Net V2 over
> SQL*Net V1, I remember that there are some peformance/network traffic
> improvements, but I cannot find our copy of the migration guide.
>
> Many Thanks
>
> Mike
  Received on Fri Oct 31 1997 - 00:00:00 CST