Data Project - Running SP via ADO

From: "Kyle Jedrusiak" <kjedrusiak@xxxxxxxxxxxxxxxxxxxxxxxx>
Date: Wed, 18 Jul 2007 13:47:26 -0400

I've looked at the ADO documentation and it's not clear to me.

I have a long SP that doesn't return any records.

I want the ability to start running it, know that it's still running so I
can let the user know and be able to stop any time after it's been started.

I am using the CurrentProject.Connection to run the SP.

I've tried both the Connection object and the Command object.

When I call the Cancel method, the SP continues to run till it's done.

If there is a way to do this correctly, what it is?

Thanks

Kyle!

.

Follow-Ups:
- Re: Data Project - Running SP via ADO
  - From: Bob Barrows [MVP]

Prev by Date: Re: First connection from Vista client to SQL Server 2005 times out
Next by Date: Re: Data Project - Running SP via ADO
Previous by thread: Re: ADO.NET and SQL Server
Next by thread: Re: Data Project - Running SP via ADO
Index(es):
- Date
- Thread

Relevant Pages

Re: Data Project - Running SP via ADO
... Kyle Jedrusiak wrote: ... I want the ability to start running it, ... I've tried both the Connection object and the Command object. ... Please reply to the newsgroup. ...
(microsoft.public.data.ado)
Re: Data Project - Running SP via ADO
... I want the ability to start running it, ... I've tried both the Connection object and the Command object. ... Microsoft MVP -- ASP/ASP.NET ... Please reply to the newsgroup. ...
(microsoft.public.data.ado)