Oracle 10g and VB6 ADO

From: CollyMitch <colmjmitchell_at_gmail.com>
Date: 10 May 2006 03:19:37 -0700
Message-ID: <1147256377.459005.47340@i40g2000cwc.googlegroups.com>

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 Received on Wed May 10 2006 - 05:19:37 CDT