Sql Query call does not work.
From my csharp web app I have a dynamic query that i need to execute and put that information in a datagrid. When the query runs I wait a bit for the page to load and I get this error when I try to put data in the dataset for the datasource.
ERROR [HY008] [IBM][CLI Driver][DB2/AIX64] SQL0952N Processing was cancelled due to an interrupt. SQLSTATE=57014
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.
Exception Details: System.Data.Odbc.OdbcException: ERROR [HY008] [IBM][CLI Driver][DB2/AIX64] SQL0952N Processing was cancelled due to an interrupt. SQLSTATE=57014
I think that the query is either timing out or my transaction log is running out of space. How would I go about increasing these numbers in csharp?
I used the debugger to get the query that was created and I used something equivilant to the microsoft sql query analyzer and it ran fine and returned data in about 1.5 minutes.