Execute SP async with ability to stop execution

From: "Kyle Jedrusiak" <kjedrusiak@xxxxxxxxxxxxxxxxxxxxxxxx>
Date: Thu, 19 Jul 2007 09:36:10 -0400

In Access XP is there a way to programatically execute a long running stored
procedure on a SQL 2000 server and have the ability to stop it at will?

ADO? DAO? DAO w/Workspaces and ODBCDirect?

Please point me to a working example if possible.

Thanks

Kyle!

.

Follow-Ups:
- Re: Execute SP async with ability to stop execution
  - From: Bob Barrows [MVP]

Prev by Date: Re: Data Project - Running SP via ADO
Next by Date: Re: Execute SP async with ability to stop execution
Previous by thread: Data Project - Running SP via ADO
Next by thread: Re: Execute SP async with ability to stop execution
Index(es):
- Date
- Thread

Relevant Pages

Connection dropouts
... server residing on the SBS server. ... The client application, from what I can tell, is a VB ... to check the pc's ability to connect to the SQL Server. ...
(microsoft.public.sqlserver.clients)
Execute SP async with ability to stop execution
... procedure on a SQL 2000 server and have the ability to stop it at will? ... DAO w/Workspaces and ODBCDirect? ...
(microsoft.public.access.modulesdaovba)
ReportPortal 2.2
... Report Portal is an XMLA web based client. ... SQL Server Analysis Services 2005 Support ... Ability to select measures on rows ...
(microsoft.public.sqlserver.datamining)
ReportPortal 2.2
... Report Portal is an XMLA web based client. ... Ability to Export to HTML and GIF ... SQL Server Analysis Services 2005 Support ...
(microsoft.public.office.developer.web.components)
ReportPortal 2.2
... Report Portal is an XMLA web based client. ... SQL Server Analysis Services 2005 Support ... Ability to select measures on rows ...
(microsoft.public.sqlserver.olap)