Sqlconnection does not support parallel transactions

views:

394

answers:

+1 Q:

Sqlconnection does not support parallel transactions

I want to run two transactions simultaneously. So i gave MultipleActiveResultSet = false in the connection string as specified in an MSDN article. But after modifying the connection string i get "Target machine actively refused". I'm working with WCF.

Any ideas in this?

Thank you.

Are you sure "Target machine actively refused" is related to parallel transactions?

It usuall means the machine is not listening on the port you're trying to talk to.

Andomar 2010-01-23 12:18:04

Yes. If i remove the MultipleActiveResultSet entry from the connection string, everything works fine.

NLV 2010-01-23 12:18:57

Can you post the connection string (without password ofc)?

Andomar 2010-01-23 12:21:46

Okie, i now feel that my question is absurd. The problem is with the code logic. Sorry.

NLV 2010-01-23 12:33:30

+1 A:

Can you explain what you're trying to do please?

A transaction is atomic and isolated (so effectively per connection). You can't do 2 simultaneous transactions for one connection/session: it makes no sense

gbn 2010-01-23 12:18:17

An MSDN page for SQL Server Compact mentions "does support parallel transactions in ADO .NET" http://technet.microsoft.com/en-us/library/ms172400(SQL.90).aspx, though I'm unsure what it means

Andomar 2010-01-23 15:59:06

Thanks. Odd concept. Not nested though.

gbn 2010-01-23 17:06:55

+1 A:

I was under the impression that MARS only really applies to the special case of getting multiple forward-only read-only resultsets on a single connection, but that regular operations have to have their own connections.

Cade Roux 2010-01-23 15:52:13

ansaurus

tags:

views:

answers:

Sqlconnection does not support parallel transactions

related questions