Periodically, I get this error message while making a call to a DB2 database using the Odbc connection string. I have tried setting the CommandTimeout of the DbCommand object to multiple values, but I still get the following error.
SQL0666 - SQL 查询超出指定的时间限制或存储限制.
SQL0666 - SQL query exceeds specified time limit or storage limit.
Is there a trick to getting this to stop erroring out. It is very odd because the same query sometimes will work and sometimes will timeout. Any help would be appreciated. Thanks!
推荐答案
我试过设置DbCommand 对象的 CommandTimeout多个值
I have tried setting the
CommandTimeout of the DbCommand object
to multiple values
我设置了 DbCommand.CommandTimeout= 0 并修复了超时错误
I set the DbCommand.CommandTimeout= 0 and this fixed the timeout error
