Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Problem with SQLOLEDB
Message
De
20/07/2006 04:44:27
 
 
À
Tous
Information générale
Forum:
Visual Basic
Catégorie:
Autre
Titre:
Problem with SQLOLEDB
Divers
Thread ID:
01137949
Message ID:
01137949
Vues:
51
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.
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform