General information
Title:
Problem with SQLOLEDB
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 occurs in 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.
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only