Yeah, the memory is released only once I close VFP. Isn't 2.6 the latest version of ADO?
And, yes, I am using this inside a MTDLL running under MTS. I'm currently having to shut down the package every 12 hours or so. I've thought about automating that, but haven't bothered with it hoping that I'd get the problem resolved.
BTW, this also occurs in VFP7 Beta 2 + Win2k Sp2 + MDAC 2.6.

>Hi!
>
>Strange. Does memory leak goes away as soon as you close VFP?
>In addition, did you tried to install the latest version of ADO?
>Finally, if you require this for automation service, I would suggest to make a supporting (controlling) service, that restart the main service each night or more often. This way you will forget about any memory leak in the main service, just because application will be restart.
>
>HTH.
>
>>Sigh. Well, I was praying that it would work. I hadn't seen SYS(1104) before. But, alas, it didn't. Same results.
>>I had already tried creating and releasing the recordset each time it loops, but moved it out to speed things up when I found that it didn't make a difference.
>>I appreciate the suggestion though :)