Re: ODBC vs SQL*Net
Date: 1996/06/04
Message-ID: <31B42F06.49F6_at_jcpenney.com>#1/1
Rodrigo Fontecilla wrote:
>
> Anybody out there has any opinion on whether ODBC or SQL*NEt is perferable.
>
> Environment is Windows NT.
>
> Speed, robustness, connectivity?
>
> Any info will be appreciated.
>
> Please e-mail to
>
> fontecillr_at_bah.com
>
> Thanks
Unless you purchse one of the few commercial drivers that do not require SQL*net, ODBC simply adds a
generic "face" to SQL*net. SQL*Net still needs to be installed on all client machines. The
connection goes something like this:
ClientAPP --> ODBC --> SQL*Net client --> SQL*Net server --> Oracle
If you write directly to SQL*Net (using OCI,for example), you will likely see a performance gain
because you eliminated the ODBC processing (actually, there is some server side ODBC stuff I forgot to
put in the above diagram). If you write to ODBC, you are not as closely tied to a single vendor for
your database. It's performance versus flexibility.
Hope this helps a little.
|_____________________________________| |__________________________|
client side server side
-Jonathan Received on Tue Jun 04 1996 - 00:00:00 CEST