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?
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?