Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Problem with SQLOLEDB
Message
 
 
À
20/07/2006 04:43:22
Information générale
Forum:
Microsoft SQL Server
Catégorie:
Autre
Versions des environnements
SQL Server:
SQL Server 2000
Divers
Thread ID:
01137948
Message ID:
01138026
Vues:
12
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--
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform