I am using a COM, wherein the COM has been migrated from VB6 to VB.Net.
While executing the same I am getting this error: transaction cannot have multiple recordsets with this cursor type change the cursor type vb.net when a recordset query is executing after a delete statement on the same connection is executed.
The delete query is executing as cn.Execute(strDelData)
The record set is running as : rs.Open(StrSalEmp, cn, ADODB.CursorTypeEnum.adOpenStatic, ADODB.LockTypeEnum.adLockOptimistic)
Don't know what cursor type to change.
Thanks & Regards
What I have tried:
rs.Open(StrSalEmp, cn, ADODB.CursorTypeEnum.adOpenDynamic, ADODB.LockTypeEnum.adLockOptimistic)