ODBC Error HYT00
Posted: Tue Apr 22, 2014 11:31 am
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
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