Re: OLE DB vs ODBC for Oracle

ODBC is more mature than OLE-DB. ODBC is supported perfectly well by Oracle (by creating and updating their own ODBC drivers).

Believe me, if you think the middleware is letting you down - it isn't.

If you haven't learned which companies to become loyal to then you soon will.

(but learning the hard way is a painful experience - its your choice)

David P.

Oracle Certified DBA

John Perseo wrote:
>
> Doug Coan wrote:
> >
> > In article <1eOD4.509$Yd.20460165_at_news1.van.metronet.ca>,
> > "kristina" <kristinah_at_netperform.com> wrote:
> > > I have the simple and quick question for you: which technology is
 quicker in
> > > access to Oracle db--OLE DB and ODBC. I have read a number of articles
 that
> > > OLE DB is better, reliable and quick. But I am just told that ODBC is
 quick
> > > for particularly Oracle. I would like to confirm this from you. Many
> > > thanks.
> > >
> > >
> >
> > We use both and here is what i understand
> >
> > - OLE-DB can be slightly faster for web access if you have e-many
> > e-users (thousands)
> > - We have had a few problems getting all the functions to to work on
> > some versions of Oracle with OLE DB.
> > - Some versions of OLE DB actually sit on top of ODBC
> > - ODBC is well established
> >
> > My 2 cents - Use OLE DB if it works, but using ODBC will probably not
> > impact you in the least. Hard core developers may not agree with me on
> > this however. :-)
>
> ODBC is obsolete. It was designed long ago. OLE DB (ADO) is 100 time
> faster.
> ODBC is also not truely supported by MS anymore.
Received on Fri Apr 07 2000 - 00:00:00 CDT