Re: using microsoft odbc vs oracle odbc

"Willy Gielen" <wgielen_at_quintessence.net> wrote in message news:<9krs4p$5f1$1_at_kilbeggan.xlink.net>...
> Do any or both handle connection pooling?

Connection pooling is actually handled by the ODBC Driver Manager, which is a Microsoft component that lives between the application and the ODBC driver. As a result, every ODBC driver will support connection pooling.

Justin Cave

>
> Willy
>
> "Justin Cave" <jocave_at_yahoo.com> schrieb im Newsbeitrag
> news:233b7a65.0108030941.39bb3694_at_posting.google.com...
> > kossack80021_at_yahoo.com wrote in message
 news:<2Zea7.15180$ar1.51918_at_www.newsranger.com>...
> > > What is the advantage of using the oracle odbc driver versus the
 microsoft odbc
> > > driver?
> >
> > Most commonly, the advantage is in the feature set that's supported.
> > The Oracle driver has support for the BLOB and CLOB data types, while
> > the Microsoft driver doesn't. The Oracle driver also generally
> > returns more complete catalog information than does the Microsoft
> > driver.
> >
> > Some folks prefer one driver over the other because of differences in
> > the way they handle certain situations. The ODBC spec contains a
> > number of instances where behavior is not specified or where driver
> > implementers are given a set of options for how to handle a situation.
> >
> > Justin Cave
Received on Thu Aug 09 2001 - 04:41:10 CEST