SQL0666 - SQL查询超过指定的时间限制或存储限制 [英] SQL0666 - SQL query exceeds specified time limit or storage limit
问题描述
每隔一段时间,我得到这个错误信息,同时使使用ODBC连接字符串DB2数据库的调用。我已经尝试设置DbCommand对象多个值的CommandTimeout,但我仍然得到以下错误
SQL0666 - SQL查询超过规定时间限制或存储限制。
块引用>
有没有窍门能让停止示数出来。这是非常奇怪,因为同样的查询,有时会工作,有时会超时。任何帮助,将不胜感激。谢谢!
解决方案
我已经尝试设置DbCommand对象$ b的
的CommandTimeout $ b多个值
块引用>
我设置DbCommand.CommandTimeout = 0,这个固定的超时错误
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 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!
解决方案I have tried setting the CommandTimeout of the DbCommand object to multiple values
I set the DbCommand.CommandTimeout= 0 and this fixed the timeout error
这篇关于SQL0666 - SQL查询超过指定的时间限制或存储限制的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!