Sign in
Microsoft.com
 
Microsoft
 
 
 

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

 > 

  • Question

  • Question
    Sign in to vote
    0
    Sign in to vote

    Hello Everyone.

    I am facing a problem when importing organization with a production server database.  The error in log file shows : ExecuteNonQuery requires an open and available Connection. The connection's current state is closed.

    at System.Data.SqlClient.SqlConnection.GetOpenConnection(String method)
       at System.Data.SqlClient.SqlConnection.ValidateConnectionForExecute(String method, SqlCommand command)
       at System.Data.SqlClient.SqlCommand.ValidateCommand(String method, Boolean async)

    Before this error, the info "Update users shows". 
    I have used oldtimeout,TCPIP,Maxuserport,TCPTimewaitdelay, Optimise optimizeorgImport, delete the reports tables and also checked this link "http://support.microsoft.com/kb/2003564".

    But at last on luck.
    I will highly appreciate who will solve this problem.
    Please help on this.

    Thanks in advance.

    Tuesday, July 17, 2012 6:03 AM