Re: Oracle 10g and VB6 ADO


"CollyMitch" <colmjmitchell@xxxxxxxxx> wrote in message
news:1147256377.459005.47340@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
Hi,

We are upgrading from oracle 8 to oracle 10g. We have about 30 VB6
applications which connect to our oracle 8 database.

When connecting to Oracle 9 and 10g and the app tries to retrieve a
recordset (50,000+ records), it seems to load the whole recordset into
memory (RAM), and then into virtual memory when this fills up. (I can
show you the system performance graphs.)

I know this is not a VB forum but my code works with oracle 8 and not 9
or 10 so I think maybe someone here could help.

FYI:

Using ADO2.5 (or 2.8) to connect and the "OraOLEDB.Oracle" provider.

I can post some example code if required.

Thanks,

Colm


Not sure what you want from us. Clearly the application needs to be fixed.
It shouldn't retrieve 50K records and cache them on the client. It would be
a rare situation where that would be proper and desirable feature. I
suspect that the developer did this because they are used to MS SQLServer
where reading data can block other readers. So they grab the whole dataset
and then disconnect from SQLServer (thus freeing locks). In Oracle there is
no knead to do that. (readers don't lock writers)
Jim


.

Relevant Pages

  • Upgrading from ADO 2.7 to ADO 2.81
    ... Recently I upgraded from ADO 2.7 to the latest. ... etc. rather than using .Net (which as better support for Oracle). ... Since installing MDAC 2.81, the recordset is not populated, and an error ... The oracle package returns a refcursor data type, and I know the package is ...
    (microsoft.public.data.ado)
  • RE: Cant pass form to sub/function and...
    ... I'll work the login form some more and see if that doesn't change anything. ... I'm sorry, but I don't have any experience using Oracle, so I guess there is ... Set rstEstData = CurrentDb.OpenRecordset ... I create a new recordset object. ...
    (microsoft.public.access.modulesdaovba)
  • RE: Cant pass form to sub/function and...
    ... I'm sorry, but I don't have any experience using Oracle, so I guess there is ... Set rstEstData = CurrentDb.OpenRecordset ... I create a new recordset object. ... user skips the Oracle login, ...
    (microsoft.public.access.modulesdaovba)
  • Oracle 10g and VB6 ADO
    ... applications which connect to our oracle 8 database. ... When connecting to Oracle 9 and 10g and the app tries to retrieve a ... recordset, it seems to load the whole recordset into ... and then into virtual memory when this fills up. ...
    (comp.databases.oracle.misc)
  • Re: Upgrading from ADO 2.7 to ADO 2.81
    ... > etc. rather than using .Net (which as better support for Oracle). ... > Since installing MDAC 2.81, the recordset is not populated, and an error ... > package via the command.execute call, ... > user-defined error code being raised explicitly by the Oracle package ...
    (microsoft.public.data.ado)