Re: VB/OO4O ACCESS to ORACLE DB

From: Steve Chapman <scc14433_at_usav01.glaxo.com>
Date: 1996/05/13
Message-ID: <3197B952.7FF1_at_usav01.glaxo.com>#1/1


richu_at_interaccess.com wrote:
>
> HI, I have just started on the path to use of VB as a GUI to ORACLE server...
> I need someone to validate my findings or invalidate...so far it seem for
> ORACLE access the fastest methods ( and there seems to be many from VB)
> in order is:
> SQL Sombrero (product using OCI calls bypassing ODBC)
> Oracle Objects for OLE (using VBX/OCI as thin layer over ODBC)
> Remote Database Objects (kinda like OO4O..thin layer over ODBC)
> Data Access Objects (Jet DB links to Oracle..but kinda not feasible for
> larger server-backend DBS)
> Data Control (SLOW as HELL thru ODBC)
>
> Am I correct?...I guess what I'm looking for is a good method to access ORACLE
> and I'm not sure between the top 3...since RDO is newer w/ VB4...is it better
> than the OLDER OO4O??? Or is OO4O still faster for ORACLE???
>
> I really dont want to do SQL SOmbrero if I dont have to...
>
> Thanx in advance....

My $.02 worth: Oracle Objects for OLE does NOT use ODBC at all. It issues calls to the Oracle Call Interface (OCI) via SQL*Net, I believe. Anyway, they call it native Oracle drivers.

steve chapman Received on Mon May 13 1996 - 00:00:00 CEST

Original text of this message