Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Problem with SQLOLEDB
Message
From
20/07/2006 04:43:22
 
 
To
All
General information
Forum:
Microsoft SQL Server
Category:
Other
Title:
Problem with SQLOLEDB
Environment versions
SQL Server:
SQL Server 2000
Miscellaneous
Thread ID:
01137948
Message ID:
01137948
Views:
60
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
Map
View

Click here to load this message in the networking platform