Hi Marco. Since my last post I have coded a stress test project to work in a two tier mode, simply opening and closing TOracleDataSet's directly without any three-tier stuff involved, and that works fine. The problem seems to have all the hallmarks of a memory leak type problem, buried somewhere in the provider.pas, or in some unit that it uses. I have tried to use codeSlueth to check for memory problem, but its not my forte and I didn't get very far. It doesn't seem to be in anything my code is doing, because in the stress test project it doesn't really run any code, its just opening and closing client datasets in a pile of threads. There's no processing of the results. If I was able to get a scaled down version of very simple server and client apps, would you be able to have a look at it for me and see if you can spot anything ?
Thanks.

I can check it out with TurboPower Sleuth. Did you use that too?

I am not familiar with that tool. I went looking for it, but I don't know where to get it any more. It looks like its been defunct a while. The turbopower.com website doesn't respond either. Anyway, I have now built a scaled down very of two apps, one for the server layer and another for the client. I have removed any dependencies to any of my own or third party components, apart from DOA obviously, and the query that it runs is off one of the Oracle system tables, so I have removed any dependency on my own database and schema too. How can I send you these ?

You can send it to marco.kalter@allroundautomations.com.

Hiya Marco. Any news ?

Sorry for the delay, I have not yet been able to check it out. I will get to this shortly though, and will get back to you.

Just for further info, I have now written the same test project that I gave you in Delphi 5, and it does NOT seem to experience the same problems. This would seem to imply that its an actual Delphi 4 bug that was somehow fixed in 5. Now sure if that helps you any. It doesn't help me too much because of the size of my applications. I can't quickly convert and release a D5 version. Ta.