• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 198
  • Last Modified:

How do I not wait for execution of Stored Procedure?

I have a VB app that is calling a stored procedure that takes 15 minutes to run (no problem as I expect this). The problem is that my VB app is waiting for SQL to return a value and so my VB app stops executing on that line of code.

How do I tell SQL to accept the execute command and release the VB app?
0
DLockwood
Asked:
DLockwood
1 Solution
 
Anthony PerkinsCommented:
You can call the Execute method with the adAsyncExecute option.

Anthony
0
 
spcmnspffCommented:
First make sure that the machine running the vb has the isql utitly.  This can be found on your sql server.
Use the shell comnd in vb to call the isql utility form the command line, to execute the stored proc . . .

0
 
DLockwoodAuthor Commented:
acperkins you were right on it! I was looking in the wrong place. It was not a SQL Server issue, but an option for my ADO Execute command.

Thanks for the help.

DLockwood
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Get expert help—faster!

Need expert help—fast? Use the Help Bell for personalized assistance getting answers to your important questions.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now