When we execute a stored proc through the Interactive SQL window we get the 0/1 returned. When calling the same stored proc via an ASP page we get 'ADODB.Recordset error '800a0e78' Operation is not allowed when the object is closed.'
The Stored Proc is executed and the data is stored....
Create and set the rs object 'Server.Create' open the conn 'Conn.Open' using a DSN. Create our string 'Execute stored_proc @char_var_1 = '"&var1&"', @int_var_2 = "&var2&", @result = -1'
SET rs = conn.Execute(string)
If Not rs.EOF Then
Else
End If
The error is pointed at the 'If Not' line. Any Ideas?
Thank you,
Bill
The Stored Proc is executed and the data is stored....
Create and set the rs object 'Server.Create' open the conn 'Conn.Open' using a DSN. Create our string 'Execute stored_proc @char_var_1 = '"&var1&"', @int_var_2 = "&var2&", @result = -1'
SET rs = conn.Execute(string)
If Not rs.EOF Then
Else
End If
The error is pointed at the 'If Not' line. Any Ideas?
Thank you,
Bill
