• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 5257
  • Last Modified:

Help with error: "Communication with the underlying transaction manager has failed"


I'm getting the above error when trying to commit to more than a single table using TransactionScope in vb.net

I'm using datasets to handle my DAL, with the code autogenerated by Visual Studio.   The error occurs when trying to do an update by calling TableAdapter.update(dataset) on a the first tableadapter, when changes are made to two seperate datatables.

The error does not occur if using just direct SQL statements in multiple commands.  
(I'm guessing this indicates that the TableAdapter is opening two connections, hence promoting the transaction to a distributed transaction...which is a little disappointing given the updates are both at the same database)

The commit works fine when only updating a single table
Both client and server are running Win Server 2k3
I can successfuly do a DHCPing from both sides
I can ping both sides
There are no firewalls active on either the client or the server

The database is SQL Server 2005 Express edition.

Anyone got any suggestions?
1 Solution
martypittAuthor Commented:
Hi riyazthad

I did read that article before posting the question, but assumed (perhaps naively) that because there were not firewalls operational on either machine, that it did not apply.

Sadly the PC crashed in the weekend, so will need a rebuild quickly.  I hope to have the rebuilt finished and tried your solution within 48 hours.  Sorry for dragging it out.

Will keep you posted.
anyone EVER get a solution to this SP1 disaster?!?!?
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

The 14th Annual Expert Award Winners

The results are in! Meet the top members of our 2017 Expert Awards. Congratulations to all who qualified!

Tackle projects and never again get stuck behind a technical roadblock.
Join Now