Error With OLEDB Provider New Transaction Cannot Enlist In The Specified Transaction Coordinator

using (TransactionScope transactionscope = new TransactionScope()) { try { function1(); //perform update on table function2(); //perfor

Solution 1:

You can not open connection in transaction more than one, so create connection object and open it outside of the transaction scope store it in session reuse it where you want within transaction, after transaction complete insure to close connection to avoid any issue.