?
Solved

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

Posted on 2006-11-17
4
Medium Priority
?
5,251 Views
Last Modified: 2013-12-03
Hi

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?
0
Comment
Question by:martypitt
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
4 Comments
 
LVL 6

Accepted Solution

by:
riyazthad earned 2000 total points
ID: 17969708
0
 

Author Comment

by:martypitt
ID: 17976082
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.
0
 

Expert Comment

by:bd9000
ID: 24069724
anyone EVER get a solution to this SP1 disaster?!?!?
0

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Well, all of us have seen the multiple EXCEL.EXE's in task manager that won't die even if you call the .close, .dispose methods. Try this method to kill any excels in memory. You can copy the kill function to create a check function and replace the …
Introduction As chip makers focus on adding processor cores over increasing clock speed, developers need to utilize the features of modern CPUs.  One of the ways we can do this is by implementing parallel algorithms in our software.   One recent…
Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…
If you’ve ever visited a web page and noticed a cool font that you really liked the look of, but couldn’t figure out which font it was so that you could use it for your own work, then this video is for you! In this Micro Tutorial, you'll learn yo…
Suggested Courses

777 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question