ZedZip
Reputation: 6472
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?
Upvotes: 2
Views: 265
Answers (1)
Mark Wilkins
Reputation: 41222
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.
Upvotes: 1
Related Questions
- How to terminate SQL statements when using DEFAULT value and OleDB?
- Cancelling SQL Query in background in .NET
- Closing connection to Access DB with OleDb
- Can we cancel query issued to sql server?
- How to Cancel SQL open
- need to cancel a long running query on sql server
- How To perform a SQL Query to DataTable Operation That Can Be Cancelled
- Command to stop querying in SQL Server
- MS Access cancel execution of pass-thru query keyboard shortcut
- Cancelling a database query dillema