Geek Answers Handbook

Error executing through Visual Studio, works fine elsewhere

I get this error:

[DB2 / 6000] SQL0952N Processing was canceled due to an interrupt. SQLSTATE = 57014

whenever I run a request through a visual studio project in vb.net. If I run the same query through the Open Office Base, it will take a long time, but it works. How can I solve the problem that caused this?

+4
source share
2 answers

Add @Tom H. to the answer. I had a timeout problem. The only thing that worked for me was:

iDB2Command cmd = new iDB2Command(sqlStatement, conn); cmd.CommandTimeout = 600;
+3
source

This SQLSTATE code indicates a user interrupt. This may be timed out. Check the timeout settings in the Visual Studio project for this particular connection and see if increasing it helps.

Since this is DB2, you may also need to look at the db2cli.ini file and increase QUERYTIMEOUT INTERVAL there.

+3
source

More articles:


All Articles