Re: Data Project - Running SP via ADO

Kyle Jedrusiak wrote:
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?

You need to run it asynchronously by instantiating the Connection object
with the WithEvents keyword. I do not know if this is possible with
CurrentProject.Connection: I doubt if it is, but you will need to ask
the Access people if it is.

Start here:
http://msdn2.microsoft.com/en-us/library/ms677579.aspx

--
Microsoft MVP -- ASP/ASP.NET
Please reply to the newsgroup. The email account listed in my From
header is my spam trap, so I don't check it very often. You will get a
quicker response by posting to the newsgroup.


.

Relevant Pages

  • 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)
  • Re: Connections and commands
    ... > I have a web app that uses a connection object as the activeConnection ... > page I dutifully close and set the connection object to nothing. ... Set cmd=nothing to destroy them. ... Please reply to the newsgroup. ...
    (microsoft.public.inetserver.asp.db)
  • Data Project - Running SP via ADO
    ... I've looked at the ADO documentation and it's not clear to me. ... I want the ability to start running it, know that it's still running so I ... 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. ...
    (microsoft.public.data.ado)
  • Re: How to Delegate Authority for Sites & Services
    ... No the NTDS Settings object, this must be done on the connection object, ... No email replies please - reply in the newsgroup ... "domain" from DC1 to domain controller DC2. ...
    (microsoft.public.win2000.active_directory)
  • Re: connection string
    ... "Chris Nebinger" wrote in message ... > The default property of the Connection object is the ... Dirk Goldgar, MS Access MVP ... (please reply to the newsgroup) ...
    (microsoft.public.access.modulesdaovba)