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?

Yipes! My first post went whizzing off into the ether. According to a Microsoft whitepaper on ODBC (this is from memory, so I may get nailed), ODBC can be implemented a number of different ways. Some implementations do all the translation on the client side, others actually do work on both the client and server. It depends on the database vendor.

I have no earthly idea what Oracle's structure is, so I should have said something like "there MAY be server side ODBC stuff". In reality, the only time I can think of where server side stuff would be really useful/necessary would be if you were using ODBC to hit flat files. I've never seen this done, but Microsoft says it can be done.

Sorry guys, I should have been clearer in my post.

-Jonathan ;) Received on Wed Jun 05 1996 - 00:00:00 CEST