Parallel SQL Transactions

[woogoo]

Hi,

Using a single SQLConnection object, 4 SQLCommand objects and 4 BackgroundWorkers I'm trying to execute 4 Parallel Transactions on a SQL Server database.

Regardless of how I set the MultipleActiveResultSets property on the Connection object's connection string I always get an error saying that Parallel Transactions aren't supported, but from what I have read and understand they are!

Can anyone help me out here?

woogoo

 

[jebenson]

What version of SQL Server are you using? SQL Server versions 2005 and up support Multiple Active Result Sets. If you are using SQL Server 2000, I think you will need to use one connection for each transaction.

I used to rock and roll every night and party every day. Then it was every other day. Now I'm lucky if I can find 30 minutes a week in which to get funky. - Homer Simpson

Arrrr, mateys! Ye needs ta be preparin' yerselves fer Talk Like a Pirate Day!

 

[woogoo]

Sorry for the delay but been out of Office. Anyway, I'm using SQL Server 2005, and I've already turned off MARS in the connection string. Which according to what I've read needs to happen when using Parallel Transactions.

But even with this done I still get the error saying that Parallel Transactions aren't supported!

So I'm confused to say the least.


woogoo

 

[jebenson]

Can you post your code, including the connection string?



I used to rock and roll every night and party every day. Then it was every other day. Now I'm lucky if I can find 30 minutes a week in which to get funky. - Homer Simpson

Arrrr, mateys! Ye needs ta be preparin' yerselves fer Talk Like a Pirate Day!

 

[woogoo]

Sorry I can't post the code in this instance, not allowed (as the powers that be get paranoid) but for what it's worth the connection string is:

Server=127.0.0.1,1433;Integrated Security=SSPI;MultipleActiveResultsSets=false;Database=SysTrans;

Any use?


woogoo