Re: SQL*Net version 1 vs. version 2

There exist both 16 bit and 32 bit versions of sql*net 2, but there is no 32 bit version of sql*net 1. And Chris is right -- you shouldn't need sql*net 1 for anything anymore -- sql*net 2 clients can even connect to sql*net 1 listeners if properly configured.

That aside, 16 bit sql*net goes with 16 bit ODBC drivers and 16 bit apps -- the same is true for 32 bit. The 16 and 32 bit sql*nets go in seperate Oracle homes, too. The only conflict you may find is that some 16 bit apps will see, but be unable to use, 32 bit ODBC data sources. Be aware of this when you choose ODBC datasource names.

Good Luck.
-Ian

Chris wrote:

> Todd Owers wrote:
> >
> > Is SQL*Net version 1 a 16-bit product? And is SQL*Net version 2 a 32-bit
> > product?
> >
> > When connecting to an Oracle database through ODBC, I understand that a
> > 32-bit application requires a 32-bit ODBC driver and a 32-bit SQL*Net layer.
> > Similarly, a 16-bit application requires a 16-bit ODBC driver and a 16-bit
> > SQL*Net layer.
> >
> > I am trying to establish a connection from an Access97 application to Oracle
> > Server 7.2.2.4.0. The client machine has SQL*Net 1.1.9.0A, and can connect
> > to the database using SQL*Plus. However, the client machine cannot connect
> > to the database from the Access97 application.
> >
> > I am speculating that the problem arises because a 32-bit application
> > (Access 97) is using a 16-bit SQL*Net layer (SQL*Net 1.1.9.0A).
> >
> > If this is correct, I presume I need to install SQL*Net version 2. If so,
> > will SQL*Net version 2 interfere with another 16-bit application that uses
> > the existing SQL*Net?
> >
> > Thanks in advance.
> >
> > Todd Owers
> > toddo_at_gcr1.com
>
> Do not use SQLNET V1 for ANYTHING new. Its dead. Use V2 only.
Received on Thu Jan 21 1999 - 01:41:51 CET