Re: ODBC vs SQL*Net
Date: 1996/06/11
Message-ID: <DsuHq1.536_at_falcon.daytonoh.ncr.com>#1/1
What about the VMARK or VISIGENIC products which are supposed to be able to replace SQL*Net on both the server and client. Anyone have any performance stats on these? I've downloaded some of the documentation from the WEB sites, but haven't yet looked at the software.
Mike
>==========Dave Heissner, 6/7/96==========
>
>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
>> > > |_____________________________________|
__________________________|>> > > snip
>> > > client side server side
>> > > 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 Tue Jun 11 1996 - 00:00:00 CEST