R
Ryan H
Hi,
My data access layer for my VB.NET 1.1 application resides on a different
server and is accessed via Remoting.
Is there a way to configure my data access layer so that I can use
Transactions? For example, I would like to do the following from the client:
Try
DataAccessLayerClass.RunSQL("UPDATE MyTable SET Column3 = "aa", ConnObj,
TransactionObj)
SendEmail()
TransactionObj.Commit
Catch
' Update or sending of email failed
TransactionObj.Rollback
End Try
Any help on how to use Transactions while the data access layer is accessed
via Remoting would be appreciated.
I am also open to rewriting my current code (i.e. change data access
location) if there is an alternative solution.
Thanks.
My data access layer for my VB.NET 1.1 application resides on a different
server and is accessed via Remoting.
Is there a way to configure my data access layer so that I can use
Transactions? For example, I would like to do the following from the client:
Try
DataAccessLayerClass.RunSQL("UPDATE MyTable SET Column3 = "aa", ConnObj,
TransactionObj)
SendEmail()
TransactionObj.Commit
Catch
' Update or sending of email failed
TransactionObj.Rollback
End Try
Any help on how to use Transactions while the data access layer is accessed
via Remoting would be appreciated.
I am also open to rewriting my current code (i.e. change data access
location) if there is an alternative solution.
Thanks.