Multiple active result sets?

[rjhilliard]

We are moving our HR package off of Oracle and on to Sql Server. I am having trouble with running one of my apps. I am performing a select and using the results to update on of the columns in the same table. I have 2 different cursors--one for the select and one for the update. I use a looping structure to read the select's result set and then update a column within the table. I receive this error.

SQL Server Native Client 11.0]Connection is busy with results for another command. I have read online I need to activate Multiple active result sets.
I am not sure how to do this.

Any help would be appreciated.

[FRBhote]

Use SqlServer in the ODBC instead of the Native Client. Too many problems with MARS.

[rjhilliard]

Changing the ODBC to Sql Server threw the same error.

[FRBhote]

A MARS error? Impossible.