Re: SQL*Net V1 and SQL*Net V2

Karl M. Nordquist <karln_at_brightwood.com.---> wrote in article <33733BFA.3F95_at_brightwood.com.--->...
> richter_at_klst.com wrote:
> >
> > Does anyone know if it's possible to get a connection between an
 Oracle
> > client with SQL Net V1 and a server working with SQL Net V2?
> > ...
>
> No, SQL*Net 1.x and SQL*Net 2.x are completely incompatible. And it is
> unfortunate, for Oracle v7.3.x does not support SQL*Net 1.x in any way,
> shape or form.
>
> [SNIP]

The above is true.

However, most applications do not check to see which version of SQL*Net they are running. Therefore, an application built to run with SQL*Net v1 will usually run with SQL*Net V2x. What you need to do is install you application (which will install SQL*Net v1, either directly from the Oracle media, or indirectly), then install SQL*Net v2x over the top, and configure sql*net v2. You may also need the required support files (on windows platforms.)

The trick is to enter the SQL*Net 2 alias where you would enter the SQL*Net v1 connect string. Setting TWO_TASK (Unix) or making registry changes to set up the default sql*net connect string may help/obviate the need to enter the connect string/alias.

I would suggest installing SQL*Net v2 on another machine if at all possible first, to debug the necessary configuration (sqlnet.ora, tnsnames.ora, + listener.ora on the server) and get that working with tnsping and SQLPlus.

apart from that, you may need to bodge the applications configuration stuff if it actually checks the format of the sql*net v1 connection string (it shouldnt, but...)

If the application uses ODBC, then just replace/reconfigure the ODBC drivers as required. Use the Oracle ones unless you know the application was built with Intersolve Visigenic etc; you may need to source the correct ODBCs from them if so.

-- 
Miles Thomas
Logica UK Ltd
thomasm "at" logica "dot" com
The above are personal opinions, and are
not necessarily the opinions of my employer.