Re: OraOLEDB.Oracle versus MSDAORA

One further point. If connecting over a slow line we have seen major performance impact with the Oracle OLEDB driver. With LAN speeds the difference is not noticeable but with a WAN or dialup it is much faster.

Bruce L-C

"Paul Clement" <UseAdddressAtEndofMessage_at_swspectrum.com> wrote in message news:81nqhv4emetci5bvf0ts29f5nqe7cg1p9s_at_4ax.com...
> On 21 Jul 2003 13:22:20 -0700, mhousema_at_ix.netcom.com (Matthew Houseman)
wrote:
>
> ¤ How would the two providers compare and contrast? Is one significatly
> ¤ better than the other in terms of stability, performance, thread
> ¤ safety, etc.
>
> Oracle's drivers are typically updated to support newer versions of their
database software. In the
> past the Microsoft OLEDB Driver (MSDAORA) was more stable, however it is
coded against OCI 7.0 and
> will no longer be updated to support newer versions of Oracle.
>
> If you're using .NET then I would recommend using the native Microsoft or
Oracle .NET library
> instead of OLEDB or ODBC.
>
>
> Paul ~~~ pclement_at_ameritech.net
> Microsoft MVP (Visual Basic)
Received on Fri Jul 25 2003 - 22:03:45 CEST