Lack of Resources in SQL Server Updating from Progress

Osmar Morais

New Member
I´m updating MS SQL Server tables from a Progress application through ADO conection and it´s working for short ranges but when I try runs for bigger periods I receive a message about lack of resources (no more resources) or fails on data provider. I see the memory usage (in Windows Task Manager) always increasing.

I´m opening and closing the conection, releasing objects but the problem remains; I tried to reduce rows in temp-tables without success.

I put all the procedures used to access MS SQL Server in a PERSISTENT PROCEDURE.

Can someone help me?