General information
Forum:
Microsoft SQL Server
Title:
Problem with SQLOLEDB
Environment versions
SQL Server:
SQL Server 2000
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.
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