RE: SQLCancel Issue

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.
Thanks,
Vivek
-----Original Message-----
From: [email protected]
[mailto:[email protected]] 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
[email protected]
http://mail.easysoft.com/mailman/listinfo/unixodbc-dev
"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".

_______________________________________________
unixODBC-dev mailing list
[email protected]
http://mail.easysoft.com/mailman/listinfo/unixodbc-dev