Automation Error (440) wiht ADO Control & DataGrid

[JohnBates]

Hello -
I am using VB6 against a SQL Server 7 db.

This is a very simple program whereby the datagrid is populated by Adodc1 without any VB code.

I added a Timer control to refresh the data grid every 10 seconds (Adodc1.Refresh) This works very well.

Problem: The program runs fine, refreshing the grid periodically.... then after running for several minutes (seems to always be about 4 - 5 minutes) get the run-time error Automation error (error 440)

The documentation for Error 440 says -" An error occurred while executing a method"

Well, the only method being executed is the .Refresh

I can only guess that there may be a Timeout problem occurring or the SQL Server db is too busy to respond...?

Has anyone had experience with Automation errors?
Thanks for any help.
John

 

[JohnBates]

more info...

The error text is "Automation Error (error 440). The object
invoked has disconnected from its client." Then a second
error "The memory at ....... address could not be read"

When the Timer's Refresh interval is set to 5 secs,
the pgm gives this error after running for 4 minutes.

When the Timer's Refresh interval is set to 10 secs,
(twice as long) the pgm gives this error after running for 8 minutes. Seems that there is a relationship between
the refresh interval and how long the pgm runs before
getting the error..... but I'm not sure what it is.


Just a thought: Each refresh reads the Top 40 records.
Could memory be getting filled up after X number of Refreshes??

John

 

[krill]

John did you ever find a solution for this issue..I'm suffering from the same problem...if you can help please let me know.

Thanks!!

 

[JohnBates]

hi krill - I will try to find my notes to determine how I solved this one. I remember it was easy though.

John