Transaction RollBack problem...

bungpeng

bungpeng

Well-known member
Joined
Sep 10, 2002
Messages
906
Location
Malaysia
I try to use Transaction rollback but I get this error message:

The SqlCommand is currently busy Open, Fetching.

What is this message mean?
 
Are you using a DataReader by chance? I know that a ReadOnly, ForwardOnly style cursor (firehose method) keeps a connection open and might cause this error. If youre using a DataReader, try moving to the end or closing the reader first, then do your rollback.

Just a guess...

-Nerseus
 
Back
Top