Re: DAO & Oracle stored proceddures

ODBC has lowest common denominator "portability". It is not as high performance or as scalable as OO4O (assuming the code is written well in both cases). Also ODBC has a SQLServer slant (gee that's not surprising) and SQLServer is about as different from Oracle as one could get.(totally different concurrency models)
Developers should spend more time with performance and scalability than "database api portability". You pay for the database, databases are different, use the capabilities of what you paid for. If you buy a car with a CD player do you refuse to use the CD player because not all cars have a CD player - it isn't standard. Of course, not. Or better yet, if you buy a high end sports car do you not use the all 300 HP, but limit yourself to 100 HP for the same reason? The end user doesn't give a rip about "databse portability"; they just want to get their work done quickly. In my experience over 90% of the time the "database portability" issue is never taken "advantage" of.

Jim

"andrey" <aakit_at_softhome.net> wrote in message news:a1po78$12qh$1_at_josh.sovintel.ru...
> Do you know word "portability" ?
> ODBC is portable solution and (in fact) open solution, with far less bugs
> then oo4o.
> However, both ODBC and OO4O can be used in ADO stack.
>
>
> "Sybrand Bakker" <postbus_at_sybrandb.demon.nl> wrote in message
> news:paj04u4m5vr0o4lkte2l07e5op9r8dck45_at_4ax.com...
> > On Sat, 12 Jan 2002 11:11:15 -0000, "Robert A.M. van Lopik"
> > <lopik_at_mail.telepac.pt> wrote:
> >
> > >Soory Peter, but I don't agree. DAO (data access objects) together with
> RDO
> > >(remote data objects) together are the predecessor of ADO. Through ODBC
> they
> > >are perfectly able to talk to Oracle.
> > >
> > >cheers
> > >rob van lopik
> > >
> > >
> >
> > Anyone needing access from VB to Oracle should avoid ODBC like *hell*,
> > as Oracle ships Oracle Objects for OLE with every client, with
> > interfaces to VB and Visual C++. OO4O is a *native* driver, which
> > doesn't suffer from the pitfalls and quircks of ODBC.
> > OO4O also comes with sample code.
> >
> > Hth
> >
> >
> > Sybrand Bakker, Senior Oracle DBA
> >
> > To reply remove -verwijderdit from my e-mail address
>
>
Received on Sat Jan 12 2002 - 10:59:03 CST