M
Mike
Hi,
I'm using Microsoft Data Block's SQLHelper to insert record in a DB.
As a parameter to the function I pass a stored procedure and all the
stored procedure parameters
I need to use transaction to do this, but my problem is that I have to
insert information across 4 databases, and as far as I know the
transaction is associated to a connection.
Am I right?
I use something like this:
Dim ConnectionOrders As SqlConnection = New
SqlConnection(csOrders)
Dim TransactionOrders As SqlTransaction =
ConnectionOrders.BeginTransaction
How can I solve this problem??
Thanks
I'm using Microsoft Data Block's SQLHelper to insert record in a DB.
As a parameter to the function I pass a stored procedure and all the
stored procedure parameters
I need to use transaction to do this, but my problem is that I have to
insert information across 4 databases, and as far as I know the
transaction is associated to a connection.
Am I right?
I use something like this:
Dim ConnectionOrders As SqlConnection = New
SqlConnection(csOrders)
Dim TransactionOrders As SqlTransaction =
ConnectionOrders.BeginTransaction
How can I solve this problem??
Thanks