469,623 Members | 1,699 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,623 developers. It's quick & easy.

Cancelling an ADO query with Oracle

Hi All,

I am running a VB.NET application which is using ADO to connect to an Oracle
9i database. I have a form which runs a query which can take a considerable
time to run depending on the criteria that is entered. This query is run on
a seperate thread as I wish to return control to the application while this
query runs. The user can cancel the execution of this query at any time by
hitting a cancel button.

My question is how to terminate this long running query through ADO? - ADO
supports a cancel function however when I run this it takes a long time to
return. I have read in other places that with the cancel - it only starts
to cancel once the first row has been returned to the calling procedure - so
if the procedure takes 20 minutes to run to return the first row then the
cancel can take at least half this time just to cancel.

So how do I cancel ADO queries quickly and cleanly??

Any suggestions will be appreciated as at this stage I am contemplating
using the alter system kill session command in Oracle

Thanks
Sandra

Jul 21 '05 #1
1 1844
Hi Sandra,

Without to know anything from a Oracle connection I say why ADO and why not
Adonet.

However you can better ask this question in the newsgroup

microsoft.public.dotnet.framework.adonet

Where or Miha and when not Kevin will answer mostly all Oracle related
questions.

Cor
Jul 21 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

12 posts views Thread by Joe Stanton | last post: by
1 post views Thread by Sandra | last post: by
12 posts views Thread by zwasdl | last post: by
2 posts views Thread by Bob Alston | last post: by
reply views Thread by devrayhaan | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.