Sharing the transaction between different connetions in different webservices

microsoft.public.dotnet.framework.adonet

10 Dec 2004 10:09 PM

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

10 Dec 2004 10:25 PM

Sahil Malik

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

Show quote

"Antonio Budano" <antonio.budano_REMOVE_TH***@poste.it> wrote in message
news:OtmB5Tw3EHA.2788@TK2MSFTNGP15.phx.gbl...
> 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
>
>