Out of memory?

[Mats]

This is my problem:

I have a project in VB that uses DCOM to call SAP. I use the BAPI GeneralLedgerAccount to retrieve accounts from SAP. In SAP I have a total of approx 8000 accounts.

The function goes as this:
Declare objects and recordsets needed.
Call own database to create recordset of companies (SQL 7.0 local installation)
For every company in my database I retrieve a list of accounts (GetList)
For every account I retrieve the details (GetDetail)
The details are inserted one at a time in my database.

My computer (~400MB RAM) runs out of memory when about 4500 account details have been retrieved and inserted.

Checking from the Task Manager I can see that it is DLLHOST.EXE that is eating up the memory at a horrible speed...

I have tried destroying recordsets in between calls, changing all possible ways of calling the functions without any improvement. I'm quite sure (??) that I do not have any extra loops in my code generating this problem.

I would be very happy if anyone could direct me towards a solution.

Thanks,
Mats

P.S. Apologies for the long explanation...