cancel ADO2.8 asynchron queries over WAN, takes long time

From: SÁRINGER Zoltán (asdf_at_asdf.hu)
Date: 12/10/04 

Date: Fri, 10 Dec 2004 16:12:50 +0100

Hello,
I wrote once this ask, without reply...
So, if I cancel ADO's asynchron query, it doesnt stop immediately... the
delay depends on the connection speed for sql, for example over slow WAN the
request totally freezes down the client PC !!!

maybe a temporary solution is to set rs=nothing after rs.cancel, but then
that thread will continue also.. creating a newer and newer thread, and
canceling it also will freeze the machine...

<off>
IS IT POSSIBLE TO DEVELOP BUSINESS APPLICATION IN VB6, or only is it
suitable for practice at home??
<on>

what do you recommend?
nobody uses asynchron ADO?

query analizer also can do stop the query.. I why not?
thank your answers very much!

Relevant Pages

  • cancel ADO2.8 asynchron queries over WAN, takes long time
    ... So, if I cancel ADO's asynchron query, it doesnt stop immediately... ... request totally freezes down the client PC!!! ...
    (microsoft.public.sqlserver.programming)
  • cancel ADO2.8 asynchron queries over WAN, takes long time
    ... So, if I cancel ADO's asynchron query, it doesnt stop immediately... ... request totally freezes down the client PC!!! ...
    (microsoft.public.data.ado)
  • Re: Parent/Child Relationship to Integrate Data in Reports
    ... I am working on updating my queries but am confident ... On the code to cancel the before update ... Create a query joining the projects and expenses tables. ... Join ProjectID from one table to ParentProjectID in the other. ...
    (microsoft.public.access.reports)
  • Re: Return to form if query unmatched
    ... Dim MyRecCount As Long ... If it doesn't pop up a message and set Cancel = True. ... record source of that form. ... If it is a sql then you should create a query with that sql, ...
    (microsoft.public.access.queries)
  • Re: Return to form if query unmatched
    ... The final solution I have gone with is using my original query as datasource ... Dim MyRecCount As Long ... If it doesn't pop up a message and set Cancel = True. ...
    (microsoft.public.access.queries)