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 execution
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...?
Has anyone had experience with Automation errors?
Thanks for any help.
John
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 execution
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...?
Has anyone had experience with Automation errors?
Thanks for any help.
John
