SQL0666 - SQL 查询超出指定的时间限制或存储限制 [英] SQL0666 - SQL query exceeds specified time limit or storage limit

问题描述

在使用 Odbc 连接字符串调用 DB2 数据库时，我会定期收到此错误消息.我尝试将 DbCommand 对象的 CommandTimeout 设置为多个值，但仍然出现以下错误.

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

这篇关于SQL0666 - SQL 查询超出指定的时间限制或存储限制的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！