1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

Cancelled Sql Query Won't Go Away

Discussion in 'DataServers and ODBC' started by pinne65, Feb 9, 2017.

  1. pinne65

    pinne65 Member

    I started a query against a sql data server which I later cancelled. It looked like the cancellation was stuck, so I closed the session. Bad move it seems. Even though the session is gone, it looks like the query is still chugging on. And yes, it was a bad query as well.

    Is there a way to gracefully cancel that query - can I just disconnect the progress user#?

    The query was started from sql server management studio against a Progress 10.02B database which is linked to from a MsSql 2005 server using the Open Edge odbc driver 5.30.00.98.
     
  2.  
  3. pinne65

    pinne65 Member

    Apparently the ODBC driver does not support cancellation of queries. Just disconnecting the user worked fine here.
     

Share This Page