ZombieCheck

25 Jan 2006 10:13 AM

Eyal S

We develop using .net 2.0 with SQL 2000 DB.
We randomly receive an error:
System.Data.SqlClient.SqlTransaction.ZombieCheck().

Does anybody have any idea ot why this happens?

Thanks

27 Oct 2006 8:16 AM

aichu

i got this error when try to save a record:
System.InvalidOperationException: This SqlTransaction has completed; it is no longer usable. at System.Data.SqlClient.SqlTransaction.ZombieCheck() at System.Data.SqlClient.SqlTransaction.Rollback() at MediaBuyingCls.addMediaBuyingDirectInter(DataTable dtMbm, DataTable dtMbd, String& mediaOrderNo) at MediaBuyingPress.btnSubmit_Click(Object sender, EventArgs e)
---
Posted via DotNetSlackers.com

27 Oct 2006 8:53 AM

Miha Markic [MVP C#]

Seems like you are doing Rollback after Complete. Is this the case?
Whats your code?

--
Miha Markic [MVP C#, INETA Country Leader for Slovenia]
RightHand .NET consulting & development www.rthand.com
Blog: http://cs.rthand.com/blogs/blog_with_righthand/

<ai***@blueocean.net.my> wrote in message

Show quote

news:eQ%23iFBa%23GHA.924@TK2MSFTNGP03.phx.gbl...
>i got this error when try to save a record:
> System.InvalidOperationException: This SqlTransaction has completed; it is
> no longer usable. at System.Data.SqlClient.SqlTransaction.ZombieCheck() at
> System.Data.SqlClient.SqlTransaction.Rollback() at
> MediaBuyingCls.addMediaBuyingDirectInter(DataTable dtMbm, DataTable dtMbd,
> String& mediaOrderNo) at MediaBuyingPress.btnSubmit_Click(Object sender,
> EventArgs e)
> ---
> Posted via DotNetSlackers.com