I am trying to figure out how to get my database uploaded to lunarpages. i am using aspx converted to mssql pages. i have followed the instructions provided by the friendly tutors on this site but this is the error i keep getting when i click submit. Can any one help?
Offending URL:
http://lesuth.lunarpages.com/mylittleadmin3/tools/query.aspxSource: System.Data
Message: ExecuteNonQuery requires an open and available Connection. The connection's current state is closed.
Stack trace: 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)
at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)
at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
at mla_gui.NewQuery.btnSubmit_Click(Object sender, EventArgs e)
at System.Web.UI.WebControls.Button.OnClick(EventArgs e)
at System.Web.UI.WebControls.Button.RaisePostBackEvent(String eventArgument)
at System.Web.UI.WebControls.Button.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument)
at System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument)
at System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData)
at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
Target site: System.Data.SqlClient.SqlInternalConnection GetOpenConnection(System.String)