Hi,
I deploy to customer my application. On my developer machine all works fine.. and as always on customer side all goes wrong
The code is simple as on example
Try
BusinessLayer.TransactionBegin("PENSOLUTIONOFFICE", lcTransactionKey, Data.IsolationLevel.ReadCommitted)
mmks_updatePSOForm(loPSOFormStoreBO)
lSaveResult = loPSOFormStoreBO.Save(True, lcTransactionKey)
If lSaveResult = MicroFour.StrataFrame.Data.SaveUndoResult.Success Then
BusinessLayer.TransactionCommit("PENSOLUTIONOFFICE", lcTransactionKey)
lcErrorMessage = "SUCCESS"
Else
Throw New Exception("An error happen during save data!")
End If
Catch ex As Exception
lcErrorMessage = ex.Message
BusinessLayer.TransactionRollback("PENSOLUTIONOFFICE", lcTransactionKey)
End Try
On customer machine BusinessLayer.TransactionCommit call an exception (free translation from german) Transaction is finised and can't be used anymore.. something like that...
The question is WHEN transaction is finished?
and why on my developer machine all works fine and there an exception happens.
Everywhere installed SQL Server 2008.
Any ideas
Thanks
Denis