Search code examples
sql-servervisual-c++oledb

VC++ OLE DB: how to cancel query?

Sometimes user run long-time query to SQL Server in application (vc++ OLE DB). How to cancel this query on the client side during the execution?

Solution

  • The ICommand interface has a Cancel method that is specifically meant for cancelling a query. If you are using ADO, then the previously mentioned method is still available via Cancel.