Re: Oracle 10g and VB6 ADO

Hey,

Thanks for your reply.

We retrieve 50 thousand rows from oracle (we only use oracle) because we want to download from the remote Oracle db to a local MS Access database, removing the need for a live oracle connection and allowing production to continue if the network is down. This may not be the most ideal way, but it was required when the network was prone to failures.

We don't *want* to cache them on the client but load, record by record, into the access db - the virtual memory caching is the issue we need fixed! The issue is that it loads all the records into memory and the PC (Win2k) soon runs out of virtual memory.

With Oracle 8 it doesn't seem to cache all the records on the client. I guess it caches one record at a time, does some work then removes it from cache, but not with 9 or 10.

Could this be an issue with ADO or the Provider not being compatible with Oracle 9 or 10?

Thanks again,

Colm Received on Wed May 10 2006 - 09:33:18 CDT