Re: ODBC vs SQL*Net

Austin Durbin wrote:
>
> Jonathan Lent wrote:
> >
> > Rodrigo Fontecilla wrote:
> > >
> > > Anybody out there has any opinion on whether ODBC or SQL*NEt is perferable.
> > >snip
> > connection goes something like this:
> >
> > ClientAPP --> ODBC --> SQL*Net client --> SQL*Net server --> Oracle
> > |_____________________________________| |__________________________|
> > client side server side
> > snip
> > because you eliminated the ODBC processing (actually, there is some server side ODBC stuff I forgot to
> > put in the above diagram).snip
> >
>
> I agreed with you until me mentioned some server side ODBC stuff.
> Could you elaborate?

There is no server-side ODBC stuff that I know of. The ODBC driver is essentially a multi-purpose Oracle client App. Now it is true that the behavior (OCI and SQL*Net traffic) may have different characteristics between you writing the OCI or Pro*C program, and an ODBC program, but that's solely due to the client behavior.

Dave Received on Wed Jun 05 1996 - 00:00:00 CEST