StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

POInner Transactionscope error: "Communication with the underlying transaction manager has failed"
primarykey
Id
644787
data
AcceptedAnswerId
644803
AnswerCount
1
ClosedDate
CommentCount
0
CommunityOwnedDate
CreationDate
2009-03-13T22:05:04.333
FavoriteCount
0
LastActivityDate
2009-03-14T04:32:50.003
LastEditDate
2009-03-14T04:32:50.017
LastEditorUserId
419
OwnerUserId
77712
ParentId
0
PostTypeId
1
Score
0
ViewCount
2066
LastEditorDisplayName
Kev
text
Body
<p>I am not sure I am doing any of this correctly. Is it because I am opening two connections? I am closing them regardless of errors. I did try putting in some inner transaction scopes and setting the second one to <code>RequiresNew</code>. The two methods are independent of each other, however, if one fails I need them both to rollback. I may have to modify how I am creating and closing the connections, I feel. Any thoughts? Here is some example code of what I am doing:</p> <pre><code>Public Sub TransMethod() Using sTran As New Transactions.TransactionScope factory1.UpdateMethod(someObject1) facotry2.insert(someobject2) sTran.Complete() End Using End Sub Public Class factory1 Public Shared Sub UpdateMethod(obj) dim someSQLParams.... DataAcces.ExecuteNonQuery(command,someSQLParams) End Sub End Class Public Class factory2 Public Shared Sub Insert(obj) dim someSQLParams.... DataAcces.ExecuteNonQuery(command,someSQLParams) End Sub End Class Public Function ExecuteNonQuery(ByVal spname As String, _ ByVal ParamArray parameterValues() As Object) As Object Dim connection As SqlConnection = Nothing Dim command As SqlCommand = Nothing Dim res As Object = Nothing Try connection = New SqlConnection(_connectionString) command = New SqlCommand(spname, connection) command.CommandType = CommandType.StoredProcedure command.Parameters.AddRange(parameterValues) connection.Open() command.ExecuteNonQuery() res = command.Parameters(command.Parameters.Count - 1).Value Catch ex As Exception CreateDataEntry(ex, WriteType.ToFile, spname) If Not (transaction Is Nothing) Then transaction.Rollback() End If Finally If Not (connection Is Nothing) AndAlso _ (connection.State = ConnectionState.Open) Then _ connection.Close() If Not (command Is Nothing) Then command.Dispose() End Try Return res End Function </code></pre>
Tags
<tsql><.net-3.5><transactionscope>
Title
Inner Transactionscope error: "Communication with the underlying transaction manager has failed"
singulars
PostAcceptedAnswerId
1. PO
  singulars
  PostTypePostTypeId
  PTAnswer
PostParentId
1. This table or related slice is empty.
PostTypePostTypeId
1. PTQuestion
UserLastEditorUserId
1. USKev
UserOwnerUserId
1. USDDiVita
plurals
PostLinksPostIdRelatedPostId
1. This table or related slice is empty.
PostLinksRelatedPostIdPostId
1. This table or related slice is empty.
PostsAcceptedAnswerId
1. This table or related slice is empty.
PostsParentIdCreationDate
1. PO
  singulars
  PostTypePostTypeId
  PTAnswer
VotesPostIdCreationDate
1. This table or related slice is empty.
CommentsPostId
1. This table or related slice is empty.

Querying!

Guidance

A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.