Experiencing Problem w/SQL Cancel (SQL0952).

[disfiction]

These reports are being submitted to the Intelligent Server via Narrowcaster Server 7.1.......

Experiencing SQL0952......request being cancelled due to an interrupt......?

We are using MicroStategy 7.1.4 going against UDB 5.2.

Our ODBC Driver version is 5.2 Fix Pack 12.......

Does anyone have any ideas what causes the Intelligent Server to disconnect?

Driver Execution mode is Synchronous ......
Using Extended Fetch......

 

[nlim]

try running the sql directly thru the testODBC32 using the same DSN and ODBC driver. We can isolate if the problem is in the Iserver this way if the SQL does not run...if it does not run, it's probably between the ODBC and the DB.
then try running the SQL in the native DB2 command interface. If that works, it's the ODBC driver, if it doesn't it's the DB.