<div>
First make sure that the machine running the vb has the isql utitly. &nbsp;This can be found on your sql server.<br />
Use the shell comnd in vb to call the isql utility form the command line, to execute the stored proc . . .<br />
<br />

</div>


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 . . .



<div>
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.<br />
<br />
Thanks for the help.<br />
<br />
DLockwood
</div>


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

<div>
<div class="content wysiwyg-content">
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.<br />
<br />
How do I tell SQL to accept the execute command and release the VB app?
</div>
</div>


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?

How do I not wait for execution of Stored Procedure?

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.