Re: VB6: OLEDB - Oracle Questions

[Quoted] Thanks, Toffie.

Are those OLEDB options stable? Are they fast?

The reason I ask is this: I have been working with VB5 and oo4o - Oracle's Objects [Quoted] for OLE (I think MS borrowed the idea). Well, oo4o is quite fast when attached to a [Quoted] bound control like MSFlexGrid, but it's not always stable; I had a lot of strange [Quoted] problems with it crashing without dignity. But it is signifiantly faster than the [Quoted] MS Remote Data Control - MSRDC - which uses ODBC. When oo4o is used without a bound [Quoted] control, it is much more stable but loading the MSFlexGrid from oo4o through VB [Quoted] code is rather slow.

Thanks again for your interest.
Jerry

toffie_at_my-dejanews.com wrote:

> > 1. Does OLEDB work well with Oracle8?
> been playing around with it for a while through the ADO wrapper (native OLEDB
> is way too hard).. no problems yet..
> > 2. Does OLEDB use native Oracle SQL or does it use Microsoft's 'Jet-SQL'?
> You have several options here. There is a 'native' OLEDB oracle 8 provider
> from Intersolv that goes 'directly' over the NET 8 to the database. Another
> option is the 'native' OLEDB Oracle7 provider (available from intersolv or
> microsoft) which goes 'directly' over the SQL*NET 2.x to the Oracle 8
> database (with oracle 7.3 functionality!!). Yet another option is the
> Intersolv or Oracle Oracle 8 driver which can be used via the OLEDB-ODBC
> bridge (default installed with OLEDB/ADO environment as at this time more
> than 80% from the database access via OLEDB is still made over the
> bridge/ODBC driver combination, instead over the 'native' relational
> providers) and will go to the oracle 8 database over NET8. Last options are
> the intersolv, microsoft or oracle Oracle 7 driver which will connect via
> OLEDB over the OLEDB-ODBC bridge and SQL*NET 2.3 (7.3 functionality only!!).
> You can get these components as free evals from the intersolv and oracle
> website, the microsoft drivers and providers are part of the MS DAC 2.0
> package which is downloadable from www.microsoft.com\data\ADO.
>
Received on Tue Dec 29 1998 - 00:00:00 CET