Re: SQL*Net & ODBC

I would tend to agree with you, however, not if you're working with a local database...if you're local, sql*net isn't used (or at least that's what I understand).

Now if you want to test your theory, just remove the TNSNAMES.ORA and/or SQLNET.ORA files from ORANT\NETWORK\ADMIN (or wherever they may be lurking)...thus no SQL*NET...can you still communicate with the DB?

I doubt it.

Paul Scrivens wrote:
>
> Hi Folks,
>
> Please could I get an argument settled ?
>
> I believe that when a P/C application is connected through ODBC to an
> Oracle database, SQL*Net is also being used as part of the "pipe", i.e. the
> client app talks to ODBC, which talks to SQL*Net, which talks to the
> listener process, which talks to the server then back the other way.
>
> Is this true ?
>
> Many Thanks in Anticipation,
>
> Paul Scrivens
> paul_at_pscriv.globalnet.co.uk
Received on Tue Jan 27 1998 - 00:00:00 CET