Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Problem with SQLOLEDB
Message
 
 
To
20/07/2006 04:43:22
General information
Forum:
Microsoft SQL Server
Category:
Other
Environment versions
SQL Server:
SQL Server 2000
Miscellaneous
Thread ID:
01137948
Message ID:
01138026
Views:
11
Take a look at http://groups.google.com/group/microsoft.public.sqlserver.server/msg/127255ab5a3a1fe0?hl=en&lr=&ie=UTF-8&oe=UTF-8

>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.
--sb--
Previous
Reply
Map
View

Click here to load this message in the networking platform