Automation Error (440) with ADO Data 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 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 is a Timeout problem occurring
or the SQL Server db is too busy to respond...?

I took the default values for Connection Timeout etc when I created
the controls.


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