Shurikn Posted June 16, 2005 Posted June 16, 2005 I have this error coming up and I dont know what it means or what to do with it: An unhandled exception of type 'System.InvalidOperationException' occurred in system.data.dll Additional information: ExecuteReader requires an open and available Connection. The connection's current state is Open, Fetching. Why would the conection state change to Fetching? and how can I turn it back to normal? Quote
Machaira Posted June 16, 2005 Posted June 16, 2005 Sounds like you have another query that's running when you're calling ExecuteReader. Quote Here's what I'm up to.
bri189a Posted June 16, 2005 Posted June 16, 2005 Or you never close the connection from your last call. Make sure you are calling dispose also! Quote
michael_hk Posted June 17, 2005 Posted June 17, 2005 Or you never close the connection from your last call. Make sure you are calling dispose also! As far as I know, calling .Dispose() will destroy the connection and the connection will not return to the pool. So make sure you know the effect of calling it. Quote There is no spoon. <<The Matrix>>
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.