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
Select from freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely and get projects done right.
Remote Share is a simple remote sharing tool, enabling you to see, add and remove remote or local shares.
The application is written in VB.NET targeting the .NET framework 2.0.
The source code and the compiled programs have been in…
Since .Net 2.0, Visual Basic has made it easy to create a splash screen and set it via the "Splash Screen" drop down in the Project Properties. A splash screen set in this manner is automatically created, displayed and closed by the framework itsel…
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…
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…