Re: SQL*Net 16 bits and SQL*Net 32 bits on the same PC

Juhani Jaakola wrote:

> Dan Nichols wrote:
>
> > Hi Philippe:
> >
> > We have SQL*Net 16 and 32 bit running on the same PC with no issues.
> >
> > Our experience has been that the two installs are completely seperate.
> >
> > SQL*Net 16 bit by default installs in a directory called: ORAWIN
> > SQL*Net 32 bit defaults into ORANT (For NT platforms) and ORAWIN95 for
> > (Windows95)
> >
> > Each has it own directory structure, and its own individual TNSNAMES.ORA
> > file.
> >
> > Also, 16 bit uses the ORACLE.INI file for program paths and settings, 32
> > bit uses the system registry.
> >
> > Other than remembering to keep the two in sync, we have had not problems.
>
> So you are using SQL*Net v2 (not SQL*Net v1) to communicate to your server,
> and you do it through the 16- and 32-bit ODBC APIs, right?
>
> Which Oracle ODBC driver version supports 16-bit ODBC with SQL*Net v2?

Supposedly, all of them do! I've been fighting with trying to get to a SQL*Net 1 instance via 16 bit ODBC from Windows 95. I haven't succeeded yet, but I can hit a SQL*Net 2 instance without problems. I get a GPF in sqlspx.dll when I try to use ODBC to SQL*Net 1 instance (think it has to do with dll versions). And yes, I know it's not supported. Any hints or resources any of you are aware of regarding this would be much appreciated.

Anyway, 16 bit ODBC version 2.0.0.3.1.1 is the most recent that I know of. See:

http://www.oracle.com/support/bulletins/odbc/html/1905.html

Enjoy!
-Ian Received on Wed Sep 17 1997 - 00:00:00 CEST