SQL0666 - SQL query exceeds specified time limit or storage limit

c# ssis odbc db2 dbcommand
Isaac Levin picture Isaac Levin · Feb 24, 2011 · Viewed 18.9k times · Source

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!

Answer

kite picture kite · Mar 3, 2011

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

Related questions

How to execute an SSIS package from .NET?

I have a SSIS package that eventually I would like to pass parameters too, these parameters will come from a .NET application (VB or C#) so I was curious if anyone knows of how to do this, or better yet …

Read More
How to access ssis package variables inside script component

How can I access variables inside my C# code which I've used in Data Flow -> Script Component - > My c# Script with my SSIS package? I have tried with which is also not working IDTSVariables100 varCollection = null; …

Read More
"Unable to read data from the transport connection: net_io_connectionclosed." - Windows Vista Business and SMTP

Unable to test sending email from .NET code in Windows Vista Business. I am writing code which I will migrate to an SSIS Package once it its proven. The code is to send an error message via email to a …

Read More