Re: Which is faster Ado or Oracle classes

Again thanks for the 411. Very helpful.

Can you point me to where it says ODBC doesn't do OUT parameters. The code I was given uses ADO and does have and uses out parameters.

Thanks again

In article <918oqu$3bj75$2_at_ID-62141.news.dfncis.de>,   "Sybrand Bakker" <postbus_at_sybrandb.demon.nl> wrote:
> 1) Yes
> 2) The problem here is that ODBC can't handle any OUT parameters to
 the
> procedure (so you're not getting anything back in your program) and
 OO4O
> does.
> In a particular project I have been involved with this was a real
 problem,
> as any status code didn't return to the VB program, the VB program
 just
> 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/
>
>

Sent via Deja.com
http://www.deja.com/ Received on Thu Dec 14 2000 - 16:52:22 CET