Memory Leak in ADO
I am using ADO 2.0 in one of my application. One Ado connection has opened in form_load event and in one timer I am checking the entries in one of the table in every 100 ms interval. I am using the following code in the timer
dim LRST as adodb.recordset
set lrst=new adodb.recordset
lrst.open "select * from table",gc_connection,adopendynamic
do while not lrst.eof
The memory usage for this program is increasing time to time. After 24 hours I could see a major increase in the memory usage. While seeing this problem I upgraded my ADO to 2.8. Still I couldn't see any change in memory usage.
What may be the reason?
Any help would be appretiated.