I am facing the following problem. Please reply it as soon as possible.


Error:-2147217900 The operation could not be performed because the OLE DB provider 'SQLOLEDB' was unable to begin a distributed transaction



Situation: Server A & Server B are connected through Linked Server.


the above error is faced on step 3

Step1: Start a Transaction in VB Code in Server A.
Step2: Fire a Update statement in the local database of Server A.
step3: Execute a stored procedure of Server B.
Step4: Commit the Transaction in VB Code in server A.
After that, above error is coming.