Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Return Completed From An Asynchronous Stored Proc

Status
Not open for further replies.
edge2000

edge2000

Programmer
May 15, 2000
36
GB
I am trying to run a stored proceedure on SQL 6,5 form VB6 with ADO, due to the size of the process the last one took 4 days, i would like to free up the VB app so that it can show the user things are still happining.

I have acheived most of this with the use of adAsyncExecute but what i am struggling with is how to pick up a response back from the stored procedure that it has finished.

I have tried using the code form MSPress Programming Visual Basic (Francesco Balena) but his ideas for the cn_WillExecute function fail on the explanation of the parameters required and how to run them.

Any other ideas or explanations appreciated.

Regards Dave


I can

Dave
dab@completebs.com
See website for more info but we can develop most things for most people.
 
Status
Not open for further replies.

Similar threads

2009luca
  • Locked
  • Question
GET date from classname
Replies
2
Views
223
2009luca
2009luca
2009luca
  • Locked
  • Question
GET splitted value from node and sub node in treeview
Replies
1
Views
231
Andrzejek
Andrzejek
sal21
  • Locked
  • Question
FORMAT output of Debug.Print .responseText (from api rest)
Replies
4
Views
309
2009luca
2009luca
sal21
  • Locked
  • Question
DOWNLOAD csv file from web
Replies
5
Views
215
strongm
strongm
sal21
  • Locked
  • Question
how to read the coordinates in from this file
Replies
3
Views
272
Ken01
Ken01

Part and Inventory Search

Sponsor

Back
Top