I'm not sure if anyone is checking this anymore who has knowledge of this stuff, but any help would be awesome. When I run my query this is what says.


Server Error in '/mssql' Application.
A potentially dangerous Request.Form value was detected from the client (sqlstmt="...NG = OFF, ONLINE = OFF, ALLOW_...").
Description: Request Validation has detected a potentially dangerous client input value, and processing of the request has been aborted. This value may indicate an attempt to compromise the security of your application, such as a cross-site scripting attack. You can disable request validation by setting validateRequest=false in the Page directive or in the configuration section. However, it is strongly recommended that your application explicitly check all inputs in this case.

Exception Details: System.Web.HttpRequestValidationException: A potentially dangerous Request.Form value was detected from the client (sqlstmt="...NG = OFF, ONLINE = OFF, ALLOW_...").

Source Error:

An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.

Stack Trace:

[HttpRequestValidationException (0x80004005): A potentially dangerous Request.Form value was detected from the client (sqlstmt="...NG = OFF, ONLINE = OFF, ALLOW_...").]
   System.Web.HttpRequest.ValidateString(String s, String valueName, String collectionName) +240
   System.Web.HttpRequest.ValidateNameValueCollection(NameValueCollection nvc, String collectionName) +99
   System.Web.HttpRequest.get_Form() +113
   System.Web.UI.Page.GetCollectionBasedOnMethod() +70
   System.Web.UI.Page.DeterminePostBackMode() +128
   System.Web.UI.Page.ProcessRequestMain() +2112
   System.Web.UI.Page.ProcessRequest() +218
   System.Web.UI.Page.ProcessRequest(HttpContext context) +18
   System.Web.CallHandlerExecutionStep.System.Web.HttpApplication+IExecutionStep.Execute() +179
   System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously) +87


i have no clue what this mean....it might refer to the fact that i do have a login page in order for people to access the site, meaning they must create a profile before they are able to view the pages.


i don't know..any help would be great.

thank u so much for responding! as the story goes, i took an online aspx tutorial class and we developed this site, not the template but my instructors template ...however the instructor never actually went through with how to publish the site. everything works fine on my own computer i just don't know how to publish it, i only know how to publish regular htm/html files. my issue yesterday actually stemmed from something lunarpages had to fix with me not being able to connect through little admin tool so i was trying to use a different service lunar pages offered, anyways long story,short lunarpages fixed that problem and  i am now doing everything exactly as your message has posted (very great message by the way) and this is the error i now get. do you think this is something lunarpages will help me with or is this still out of their realm because i have no idea what this error means. If you can respond that great! i appreciate it so much, this is actually part of my final masters project and its due monday! i've been trying for over a month to get my site published! i'm supposed to graduate may 10th.

Offending URL: http://lesuth.lunarpages.com/mylittleadmin3/tools/query.aspx

Source: 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)

thank u!

did exactly what you said with the directions you provided still go this

Offending URL: http://lesuth.lunarpages.com/mylittleadmin3/tools/query.aspx

Source: 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)



I wonder what connection it is referring to that is closed....lunarpages says they will charge me 75 dollars for any help...but i don't feel like this one may be my fault....

The step where you copy and paste the text into the new query box and you hit submit. That is the error that appears on the page. It did it for both .sql files I tried to upload.

Actually ignore me. It was a bug in my code

Its great man..You did a very hard work on it..so good job man..
I appreciate your work..and thanks for sharing..

Wish i found that a mth ago