ODBC Error HYT00

[geyer]

Hello,
I use the command
WFOPEN(type=odbc) "CalcProd" "select * from Calc.Angebot group by whg, wug, artid having count(*) >= 300 order by artid, whg, wug"
and receive the ODBC Error HYT00 (see attachment). the database is quite large (~600000 records).
The error occurs only /occasionally/ if I use the command
WFOPEN(type=odbc) "CalcProd" "select whg, wug, artid from Calc.Angebot group by whg, wug, artid having count(*) >= 300 order by artid, whg, wug"
(I have to issue the same command one or two times until it works).
Commands like
WFOPEN(type=odbc) "CalcProd" "select * from Calc.Angebot where artid=5"
usually work without a problem.

I searched the web and found indications that HYT00 refers to an SQL timeout problem. Is there any way to resolve this problem from within EViews?

Thanks!

~~Alois

[EViews Steve]

Read this posting and search for "timeout":
http://forums.eviews.com/viewtopic.php?f=3&t=28

Steve