Microsoft KB Archive/70844

PRSQL9103024: Cannot Read Results After SQL Server Times Out ID Number: Q70844

1.10 OS/2 buglist1.10

Summary:

PROBLEM ID: PRSQL9103024

SYMPTOMS When a read from SQL Server times out, and a cancel is sent to the server to stop the current query, the server ignores the next command. This hangs the connection on the next attempt to read results.

CAUSE The server does not acknowledge the next command sent to it after a timed out connection returns an attention packet.

RESOLUTION Send any command to the server after the canceled query returns. Then, call dbcancel. The server will properly return a done token with the acknowledgment for the second attention signal. Further commands will then be processed as normal.