Run time error 40088

[Saurabh Bhargava]

With using Vb 6 Msql 7.0 ,we use Begin Transaction and Commit/Rollback Transaction method to update or rollback the data. The problem that we are facing is after every commit or rollback if we click on the next record it display error Runtime Error 40088 No Open Cursor or Cursor Closed. How can this problem be solved.

[kieran_rush]

Check in the SQL properties under the connection TAB if you have enabled the option Close Cursor on Commit, if you do uncheck it, may be this is the problem

Regards
RSV