Microsodt DataBlocks SQL Helper and transactions acroos 4 databases

  • Thread starter Thread starter Mike
  • Start date Start date
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
 
Back
Top