[unixODBC-dev] SQLCancel Issue

Vivek Venugopal Vivek.Venugopal at symphonysv.com
Tue Mar 25 13:06:27 GMT 2008

Hi all,
With Threading = 0 parameter SQLCancel still failed.
SQLExecDirect doesn't seem to return.
Yes we are indeed trying to cancel from a different thread.

Comments Please.
-----Original Message-----
From: unixodbc-dev-bounces at easysoft.com
[mailto:unixodbc-dev-bounces at easysoft.com] On Behalf Of Nick Gorham
Sent: Monday, March 17, 2008 8:15 PM
To: Development issues and topics for unixODBC
Subject: Re: [unixODBC-dev] SQLCancel Issue

Vivek Venugopal wrote:

>Hi All,
>There seems to be some issue with SQLCancel.c.
>SQLCancel didn't seem to work with oracle driver, when reported to
>oracle they came up with a fix in unixODBC driver manager.
>Below is the fix,
>File: ..\unixODBC-2.2.12\DriverManager\SQLCancel.c
>At line number 137 comment/remove the below line.
>thread_protect( SQL_HANDLE_STMT, statement );
>Comments please.
Well, I don;t know, I haven't had that reported.

I assume you are canceling from a different thread to the thread running

the query?

If so, IMHO, the correct solution is to inform unixODBC that the driver 
is thread safe, and it doesn't have to searialize calls into the driver 
by adding

    Threading       = 0

to the driver entry in your odbcinst.ini file.

>Hope I am reporting this bug at the right forum.
Yep, its the right place :-).

Nick Gorham
unixODBC-dev mailing list
unixODBC-dev at easysoft.com
"This email and any files transmitted with it contain confidential, proprietary, 
privileged information of Symphony Services Corp (India) Pvt. Ltd. and are intended 
solely for the use of the recipient/s to whom it is addressed. Any unauthorized 
notifying, copying or distributing of this e-mail, directly or indirectly, and the 
contents therein in full or part is prohibited by any entity who is not a recipient. 
Any email received inadvertently or by mistake should be deleted by the entity who 
is not a recipient thereof. You may be pleased to notify the sender immediately by 
email and the email should be deleted from your system".

More information about the unixODBC-dev mailing list