You must Sign In to post a response.
  • Category: ASP.NET

    ExecuteNonQuery requires an open and available Connection.

    Our applicataion is asp.net and 300 people are using this application and some time we are getting this error

    ExecuteNonQuery requires an open and available Connection. The connection's current state is closed.

    We are getting this error very frequently and after this error rollback is not happening. Kindly help me.
  • #620039
    Try this,


    IntegratedSecurity = true; == wrong

    IntegratedSecurity = false; == correct

  • #620050
    Hi,
    the error states that you have connection pool size problem.
    please follow the link below and refer my post there.
    http://dotnetsquare.com/resources/37-What-is-Connection-Pooling-in-Net

    If it helps you then Rate this.

    Best Regards,
    Manoranjan Sahoo
    http://www.dotnetsquare.com
    Blog: http://blog.msahoo.net

  • #620051
    Hi,
    the error states that you have connection pool size problem.
    please follow the link below and refer my post there.
    http://dotnetsquare.com/resources/37-What-is-Connection-Pooling-in-Net

    Thank you.

    If it helps you then Rate this.

    Best Regards,
    Manoranjan Sahoo
    http://www.dotnetsquare.com
    Blog: http://blog.msahoo.net

  • #620059
    Hi,

    Before the execute query check if connection is closed. if connection is closed open that and execute the query.


    Thanks & Regards,
    Prabha

    Thanks & Regards,
    Prabha


  • This thread is locked for new responses. Please post your comments and questions as a separate thread.
    If required, refer to the URL of this page in your new post.