I am using ADO through Excel to get at several large oracle databases.
One of the things I am doing is extracting data from the database and transforming it into xml. (I am stuck with oracle 8 so I can't do this database end).
What seems to be happening though is that the machine locks up whilst rs.open ... is executing. I have tried to use the adAsyncFetch option in the open command and then the FetchProgess event however I can not seem to get processing of rows and the retrieval to tie up.
I always seem to get to the point that the app is trying to process a row that has not yet been returned.
If I was doing this in any other language, I would probably use different threads but I guess I am a little stuck with this if I am using VBA.