Re: VB6: OLEDB - Oracle Questions

In article <36898DCC.9CC9E4ED_at_ican.ca>, Jerry Apfelbaum <japfelba_at_ican.ca> wrote: These OLE-DB providers are very new and still have a lot of bugs that need to get out of their systems, so no.. in my opinion they are not yet stable enough to trust your bussiness to them. Speed differs.. most providers are 95% of the odbc driver logic with an OLEDB/ODBC bridge build around them so you could say that they give you the same performance as the ODBC drivers did (these are also more stable but do not have internally the OLEDB architecture). Speed is something that need to be tested out on provider per provider basis. At this time I should recommend to work with the ADO interface but give it a wait and some thorough testing before using the providers.. All three ODBC drivers have been there for a while and are as solid and fast as you can get 'em and I never saw a problem with bridge..

Toffie.

> 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
> for OLE (I think MS borrowed the idea). Well, oo4o is quite fast when
 attached to a
> bound control like MSFlexGrid, but it's not always stable; I had a lot of
 strange
> problems with it crashing without dignity. But it is signifiantly faster than
 the
> MS Remote Data Control - MSRDC - which uses ODBC. When oo4o is used without a
 bound
> control, it is much more stable but loading the MSFlexGrid from oo4o through
 VB
> 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.
> >
>
>

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Wed Dec 30 1998 - 00:00:00 CET