Sharing the transaction between different connetions in different webservices

  • Thread starter Thread starter Antonio Budano
  • Start date Start date
A

Antonio Budano

Hi there,

How can I share the same transaction between two webmethods each in two
different webservices?
I want to be sure that when the client calls the two webmethods, there will
be the data integrity, I mean if the second method will fail, also the
update made by the first method must be rolled back.
Is there any opportunity to do it without using COM+? I have the webservices
and the MSSQL DB on the same box so I would like to use some ADO/SQL native
possibility.
I had a look on how to use MSSQL sp_getbindtoken and sp_bindsession but I
don't know how these SP could be useful to me.
Is there a way to do it with ADO?

Thanks

Antonio
 
The only other way AFAIK you can do this without using COM+ is to use a
remote login and basically emulate that you are all within the same
transaction - however I don't think how you can make that to work with 2 web
services (making 2 calls I presume).

- Sahil Malik
http://dotnetjunkies.com/weblog/sahilmalik
 
Back
Top