"Cannot access a disposed object.\r\nObject name: 'Transaction'." - C# Discussion Boards

Re: "Cannot access a disposed object.\r\nObject name: 'Transaction'."

30-Jun-09 22:04

hello

I ran into this error message while before/while/after insert into ShopMessage...

<br />
   		Message	"Cannot access a disposed object.\r\nObject name: 'Transaction'."	string<br />

I'm using TransactionScope with timeout set to zero (i.e. infinite). Googled a bit still quite clueless.

This is how I wrap Database calls in TransactionScope

<br />
<br />
					using (oScope = new TransactionScope(TransactionScopeOption.Required, TimeSpan.FromMilliseconds(0)))<br />
					{<br />
                                                // Here we have some ADO.NET calls + some NHibernate calls.<br />
						nGeneratedId = SaveCoreOperations(ref oShop);<br />
						oScope.Complete();<br />
					}<br />

Here's the stack trace

<br />
   at System.Transactions.Transaction.get_IsolationLevel()<br />
   at System.Data.SqlClient.SqlDelegatedTransaction..ctor(SqlInternalConnection connection, Transaction tx)<br />
   at System.Data.SqlClient.SqlInternalConnection.EnlistNonNull(Transaction tx)<br />
   at System.Data.SqlClient.SqlInternalConnection.Enlist(Transaction tx)<br />
   at System.Data.SqlClient.SqlInternalConnectionTds.Activate(Transaction transaction)<br />
   at System.Data.ProviderBase.DbConnectionInternal.ActivateConnection(Transaction transaction)<br />
   at System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject)<br />
   at System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection)<br />
   at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory)<br />
   at System.Data.SqlClient.SqlConnection.Open()<br />
   at NHibernate.Connection.DriverConnectionProvider.GetConnection()<br />
   at NHibernate.Impl.SessionFactoryImpl.OpenConnection()<br />

Any idea?

dev

Manas Bhardwaj30-Jun-09 22:13

Re: "Cannot access a disposed object.\r\nObject name: 'Transaction'."

30-Jun-09 22:13

devvvy wrote:
SaveCoreOperations(ref oShop);

I don't think you need a ref here.

Manas Bhardwaj
Please remember to rate helpful or unhelpful answers, it lets us and people reading the forums know if our answers are any good.

devvvy1-Jul-09 1:14

Re: "Cannot access a disposed object.\r\nObject name: 'Transaction'."

1-Jul-09 1:14

yes you're right about not needing the ref, but that's not what i am asking either.

I am suspecting TransactionScope called Transaction.Dispose somehow.

dev

Manas Bhardwaj1-Jul-09 1:41

Re: "Cannot access a disposed object.\r\nObject name: 'Transaction'."

1-Jul-09 1:41

devvvy wrote:
using (oScope = new TransactionScope(TransactionScopeOption.Required, TimeSpan.FromMilliseconds(0)))
{
// Here we have some ADO.NET calls + some NHibernate calls.
nGeneratedId = SaveCoreOperations(ref oShop);
oScope.Complete();
}

Where is oScope used? Confused | :confused:

Manas Bhardwaj
Please remember to rate helpful or unhelpful answers, it lets us and people reading the forums know if our answers are any good.

devvvy1-Jul-09 1:41

Re: "Cannot access a disposed object.\r\nObject name: 'Transaction'."

1-Jul-09 1:41

some inside SaveCoreOperation and hint, death came after many iterations

dev

Manas Bhardwaj1-Jul-09 1:46

Re: "Cannot access a disposed object.\r\nObject name: 'Transaction'."

1-Jul-09 1:46

But you never passed oScope to this method. It takes the only parameter which is oShop Confused | :confused:

Manas Bhardwaj
Please remember to rate helpful or unhelpful answers, it lets us and people reading the forums know if our answers are any good.

devvvy1-Jul-09 1:49

Re: "Cannot access a disposed object.\r\nObject name: 'Transaction'." [modified]

1-Jul-09 1:49

why'd you need to, scope wraps code whether inline or not between "using" open and close bracket.

using (oScope = new TransactionScope(TransactionScopeOption.Required, TimeSpan.FromMilliseconds(0)))<br />
{<br />
nGeneratedId = SaveCoreOperations(oShop); // This method do direct ADO.NET + NHibernate calls using same connection (I don't think Any open/close/reopen happened here but it's a lot of code in here...)<br />
oScope.Complete();<br />
}

I am suspecting perhaps from within "SaveCoreOperations" oConn used was opened/closed then "Re-opened"... not sure

dev

RussVB25-Aug-09 16:38

RussVB

25-Aug-09 16:38

You can get this error message if your Distributed Transaction Coordinator service is not running. Use Administrative Tools to check the Status of the service has Started and that the Startup Type is Automatic.

Also, the default timeout/timespan is 1 minute and the default machine config caps it to 10 minutes.

modified on Wednesday, August 26, 2009 11:14 PM

Cancel Events

satsumatable30-Jun-09 21:56

satsumatable

30-Jun-09 21:56

Hi
Im placing some controls dynamically on tool strip control and i'm handling that controls click event as well tool strips click event. But when ever i click the control it triggers both the event.

I want to cancel tool strips event when i click the control.. how can i do this?

DaveyM6930-Jun-09 22:06

DaveyM69

30-Jun-09 22:06

Do you need the toolstrip's Click event to be handled at all (I've never found a need for it personally as all I'm ever interested in is the items, not the strip)?

Dave
BTW, in software, hope and pray is not a viable strategy. (Luc Pattyn)
Visual Basic is not used by normal people so we're not covering it here. (Uncyclopedia)
Why are you using VB6? Do you hate yourself? (Christian Graus)

satsumatable30-Jun-09 22:34

satsumatable

30-Jun-09 22:34

Well, I'm handling tool strip click event also with different context.

Cracked-Down30-Jun-09 22:58

Cracked-Down

30-Jun-09 22:58

Use e.Cancel = true;

How to attach file when sending emails

musefan1-Jul-09 1:21

musefan

1-Jul-09 1:21

What is it that you are using the ToolStrip's click event for?

Life goes very fast. Tomorrow, today is already yesterday.

dabuskol30-Jun-09 21:54

dabuskol

30-Jun-09 21:54

Hi,

Do you have any idea on how to attache image/docs/pdf saved from SQL DB then send it to email?
All the attachements of diff. docs are all saved in our SQL DB, they want me to send the attched files as per record at attachment to email.

PLSzzz.

Dabsukol

Re: How to attach file when sending emails

Manas Bhardwaj30-Jun-09 21:58