Interrupting a long running query with SQLCancel()

[sebflaesch]

Hi all,

Sybase ASE 15.5, Linux x86 32b, using Sybase ODBC client.

I am trying to implement SQL interruption when the ODBC client with
SQLCancel().

After calling SQLExecute(), the server is working and the client can
normally execute a SQLCancel() to interrupt the SQL execution and get
an error returned by SQLExecute().

Actually this code is working fine with other ODBC clients (SQL Native
Client, DB2 CLI, EasySoft ODBC for SQL Server), but with Sybase I get
an unexpected behavior:

The connection is lost, I get following error:

SQLSTATE 108S01
SQLCODE -30046
[Sybase][ODBC Driver]Connection to Sybase server has been lost. All
active transactions have been rolled back

This is to me an important missing feature.

Thanks for reading
Seb