HighTechTalks DotNet Forums  

Transaction fail when called via remoting

Dotnet Framework (ADO.net) microsoft.public.dotnet.framework.adonet


Discuss Transaction fail when called via remoting in the Dotnet Framework (ADO.net) forum.



Reply
 
Thread Tools Search this Thread Display Modes
  #1  
Old   
Johan Karlsson
 
Posts: n/a

Default Transaction fail when called via remoting - 08-22-2007 , 09:06 AM






Hi!

I have an application where the client call the server over .net remoting
(tcp).

The final code to be called looks something like this:

Public Sub Update()
Using t as New Transaction
UpdateThisObject()
UpdateChildObjects() ' <---
System.Transaction.TransactionException occurs here if remoted
t.Complete()
End Using
End Sub

I've setup a testcase that calls this code locally and remotely. The remote
call fails with a TransactionException whilst the local call succeeds. This
behavior is reproduceable within our development environment. I could try to
boil the code down to the smallest possible codebase to reproduce the error.

The underlying database is Sql Server 2005 on a remote computer. .net
framework 2.0.

Has anyone seen this behavior before?

Thanks
Johan



Reply With Quote
  #2  
Old   
Johan Karlsson
 
Posts: n/a

Default Re: Transaction fail when called via remoting - 08-23-2007 , 05:56 AM






Additional information,

The connection object is created (with the same connection string) at each
call.

/ Johan

"Johan Karlsson" <johan.karlsson (AT) caretech (DOT) se> skrev i meddelandet
news:2CE3833B-5E6C-4044-9CD9-EF23520F1159 (AT) microsoft (DOT) com...
Quote:
Hi!

I have an application where the client call the server over .net remoting
(tcp).

The final code to be called looks something like this:

Public Sub Update()
Using t as New Transaction
UpdateThisObject()
UpdateChildObjects() ' <---
System.Transaction.TransactionException occurs here if remoted
t.Complete()
End Using
End Sub

I've setup a testcase that calls this code locally and remotely. The
remote call fails with a TransactionException whilst the local call
succeeds. This behavior is reproduceable within our development
environment. I could try to boil the code down to the smallest possible
codebase to reproduce the error.

The underlying database is Sql Server 2005 on a remote computer. .net
framework 2.0.

Has anyone seen this behavior before?

Thanks
Johan




Reply With Quote
Reply




Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.4
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.