I’m not sure if it is a reliable way to invoke the error, but it does happen often when I did the following:
Because I’m running my Avast Pro 4.1.319 on an unattended WinXP system (which I use as file, web and mail server), I want to have maximum protection but I’m unable to use the ‘push’ functionality. So, while in the Scheduler folder I created 4 scheduled tasks:
[*]‘Virus Definitions Update 0230’, which updates the definitions at 02.30,[*]‘Virus Definitions Update 0830’, which updates at 08.30,[*]‘Virus Definitions Update 1430’, which updates at 14.30, and[*]‘Virus Definitions Update 2030’, which updates at 20.30.
Then I created a 5th scheduled task, a scan of all disks, and called it ‘Virus Scan 0300’, which runs at 03.00 every morning.
Now, while in the Scheduler folder, try editing the ‘Virus Scan 0300’ schedule, and on my system, the error occurs at least 50% of the time. That is, the runtime error occurs, and the Enhanced interface dies.
Everytime this error occurs, I get an entry in the log file, under ‘error’:
ODBC function SQLAllocHandle() - dbsObjectsQuery() failed. Error description: .
(That’s right, no description.)
Workaround: I’ve found the only way to reliably edit the schedule, is to go to the Tasks folder, open the task, and change the schedule there.
Also: I don’t understand how Avast is sorting the schedules. If you look at the Scheduler folder, the scheduled tasks don’t seem to be sorted by name or creation date etc. If I click on the column header (e.g. ‘Name’), then the scheduled tasks move around every time I click, but not alphabetically.