Visual Basic 6
Sybase Sql Server 11.9.2.
Open Client 11.9.2
I have a bunch of stored procedures that i call to insert records into
various tables. For each stored procedure i call, there is an output
parameter integer, which becomes one of the parameters to the next stored
procedure call. I haved learned that i will need to use an ADO Command
object in order to retrieve the parameter.
I have successfully implemented code to run all the stored procedures using
ADO Command objects. The problem is, when i put a BeginTrans on the ADO
Connection object the Execute called from the Command object causes the
Connection object to crash with an error message similar to:
"Transaction cannot have multiple recordsets with this cursor type. Change
the cursor type, commit the transaction, or close one of the recordsets."