Re: From oracle to MS access through VB5

Yuck, I checked out that link. OO4O doesn't look that appealing.

Have you considered ADO? It's just as native as OO4O.

Steve

> But I can't use ODBC driver.

    Are you telling me you can't use the ODBC driver along with Oracle Objects for OLE? OO4O locks other types of clients from using the Oracle database?

    You need to find out if it is technically possible and reliable.

    If it IS a reliable solution, use the method I mentioned. Copying row by row using something like OO4O or DAO is going to be SLOW. You may be able to speed it up marginally if OO4O can populate a Variant Array
with a bunch of rows. However, Updating row-by-row is still going to kill you.

    Linking your Access Database to the Oracle database and using a INSERT INTO [Table] SELECT statement is your best bet. I'm not too familiar with Oracle, but maybe you can link to Access from Oracle and let Oracle populate the table using INSERT INTO [Table] SELECT.

Steve

> I am using Oracle Objects for OLE (OO4O), example
> http://infoboerse.doag.de/mirror/frank/faqoo4o.htm#CONNECT
>
> create a oracle dynaset "Set OraDynaset =
> OraDatabase.DbCreateDynaset("select empno, ename from emp", 0&)".
>
> and try to save the data to local MS Access table.
>
> That's why I try to loop through the dynaset and insert data one by one
> into MS Access in VB5.
>
> But this method is too slow. Any Suggestions?
>
> Thanks,
>
> Arthur
Received on Wed Feb 21 2001 - 16:12:18 CET