Oracle OLE objects has some nice features that make it very fast. You can
define a parameter for a query (e.g. select * from my_table where
my_col=:myParam) and use the refresh mechanism. Basically, it is allowing
you to use host variables and it saves a lot of CPU cycles on the server.
Jim
Norris <johnnie_at_cooper.com.hk> wrote in message
news:7r25b9$2lfs$1_at_adenine.netfront.net...
> ADB/OLE-DB is good if you connect to SQL Server. But if you are using
oracle database, I think Oracle Object for OLE is much better. For example
the support of PL/SQL is good in OO4O. I have installed OO4O from 8.0.5
(2.3) and 8i (8.1.5). It runs fast in Excel but I haven't compared with ADO
(2.1) which I think it is still immature. There are still a lot bugs and
limitations need to improve
>
> In comp.databases.oracle.misc GAB <news3_at_baxnet.net> wrote:
> > Has anyone ever had any experience with 0040? Why would I use this over
> > say, ADO? I understand it's OLE, or OLE-DB to be specific. But upon
> > installation of 0040 from 8.5 (8i), it bombed VB so it won't even start.
> > (Complains about a corrupt dll).
>
> > But the real question is - is Ole-db really that much better? Easier?
> > More robust? Quicker? Neater? Slicker?
>
> > GAB
>
> --
> Have several nice days...
> ===================================================================
> Opinions are mine and do not necessarily reflect those of the Corp.
> http://www.ntfaq.com
> http://www.jsiinc.com/reghack.htm
> http://www.oconnell.net/Sybase_FAQ
> http://www.cyberport.com/~tangent/programming/winsock/
> ===================================================================
Received on Tue Sep 07 1999 - 14:32:13 CDT
