Re: ODBC vs SQL*Net

Comparing ODBC to SQL*Net is an Apples to Oranges situation... you should be comparing ODBC to a direct OCI connection. Either way you will still need SQL*Net running on the client and server side. A larger number of tools can use ODBC while OCI implementations are usually written by a vendor for a specific tool (such as PowerBuilder Enterprise). Generally OCI has given better performance too but I think a number of ODBC drivers for Oracle have come out which may be changing that.

Any additional thoughts on this??

Dave H.

> 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?
  Received on Fri Jun 07 1996 - 00:00:00 CEST