Microsodt DataBlocks SQL Helper and transactions acroos 4 databases

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Microsoft Data blocks and transactions in more than 1 database 1
Transaction with stored procedure 9
SCOPE_IDENTITY and parameters during insert 6
Problem with Connection based Transaction in SQL Helper class 4
Nesting SQL Server 2005 transactions in VB.NET 2
Transactions: Puzzling Error Message 7
Concurrent Access in Transactions 2
Nested transactions with SQL connection object - how? 0

Top