Re: Which is faster Ado or Oracle classes

1. Yes [Quoted]
2. The problem here is that ODBC can't handle any OUT parameters to the [Quoted] [Quoted] procedure (so you're not getting anything back in your program) and OO4O does. [Quoted] In a particular project I have been involved with this was a real problem, [Quoted] as any status code didn't return to the VB program, the VB program just [Quoted] proceeded regardless of any sp outcome.

Hth,

Sybrand Bakker, Oracle DBA

<fuckingstupid_at_my-deja.com> wrote in message news:916bhg$9rg$1_at_nnrp1.deja.com...
> Thanks for your reply I found it informative. I'm using the oracle
> classes like ODatabase, ODynaset and the like if thats what you mean by
> Oracle Ole for Objects. Is that right?
>
> I took this part of my project over from another programmer who wrote
> it all in ADO. He was able to call stored procedures by executing a sql
> command with Begin; call procname; end; . So I must be missing
> something when you say odbc doesn't deal with stored procedures. Could
> you expand on that as well ?
>
>
>
> In article <9169dh$33spg$6_at_ID-62141.news.dfncis.de>,
> "Sybrand Bakker" <postbus_at_sybrandb.demon.nl> wrote:
> > If you mean Oracle Ole for Objects:
> > this is a native driver, which directly interfaces through sqlnet, and
> > supports many features not supported by ODBC (communication with
 stored
> > procedures for instance). Also OO4O is relatively stable, while
 there are
> > no two different ODBC drivers behaving exactly the same. Your app is
> > definitely going to be more reliable as your are not dependent from
 all kind
> > of ODBC drivers people might already have on their system.
> >
> > Hth,
> > Sybrand Bakker, Oracle DBA
> >
> > <fuckingstupid_at_my-deja.com> wrote in message
> > news:9160o2$5g$1_at_nnrp1.deja.com...
> > > I was using ADO but was playing around with the oracle classes
> > > (oconnect etc etc) , I'm wondering which is faster.
> > >
> > > I'm thinking the classes are because ado is using ODBC and has to go
> > > thru all that. I'm not sure how oracle is doing it , probably rpcs
 in
> > > their lib.
> > >
> > > I might have to explain to my boss why I changed from ado to oracle
> > > classes.
> > >
> > >
> > > thanks
> > >
> > >
> > > Sent via Deja.com
> > > http://www.deja.com/
> >
> >
>
>
> Sent via Deja.com
> http://www.deja.com/
Received on Wed Dec 13 2000 - 06:39:04 CET