I am trying to call a stored procedure, passing the information it needs then have the stored procedure write to a SQL table. Here is what I am calling
$Q = "Exec SQL_procedure_insert ' " $VAR1 + "','" + $VAR2 + "'"
#RETURN = SYS-SQL($Q)
Then I get the error message "Connection is busy with results for another command" and it does not write to the file.
anyone have any idea why this would happen.
The sql command does work properly if you run it from the SQL management studio.
Ryan
Ryan
Member Since 07 Jun 2007Offline Last Active Jul 19 2010 02:01 PM