The information in this article applies to:
Product: Metastorm BPM
Version: 7.x
Issue
When publishing a procedure to a SQL Server 2005 database, the following error is generated:
Error - Transaction cannot have multiple recordsets with this cursor type. Change the cursor type, commit the transaction, or close one of the recordsets
Resolution
- This error is generated if the DSN used by the Designer uses the SQL Native Client ODBC driver. Recreate the DSN using the SQL Server driver.
