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.