Hi

I am occasionally getting the above error from an ASP.NET application that inserts documents into a SQL database. It had been running without this problem for several months and suddenly this problem has raised it's head twice in the last few days

I have narrowed it down to happening when documents are being inserted into the database, and while this is happening other queries can still be executed without any problems - including other inserts

The full error message is as follows, where line 247 is the insert

System.Web.HttpUnhandledException: Exception of type System.Web.HttpUnhandledException was thrown. ---> System.Data.SqlClient.SqlException: General network error. Check your network documentation
at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream
at System.Data.SqlClient.SqlCommand.ExecuteNonQuery(
at aifl_na.downloadReadingTest2.Page_Load(Object sender, EventArgs e) in c:\inetpub\wwwroot\aifl-na\Secure\downloadReadingAssessment2.aspx.vb:line 24
at System.Web.UI.Control.OnLoad(EventArgs e
at System.Web.UI.Control.LoadRecursive(
at System.Web.UI.Page.ProcessRequestMain(
--- End of inner exception stack trace --
at System.Web.UI.Page.HandleError(Exception e
at System.Web.UI.Page.ProcessRequestMain(
at System.Web.UI.Page.ProcessRequest(
at System.Web.UI.Page.ProcessRequest(HttpContext context
at System.Web.CallHandlerExecutionStep.System.Web.HttpApplication+IExecutionStep.Execute(
at System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously

The only way Ihave managed to stop this happening is to restart the IIS server that connects to the database. As far as I can tell there is nothing wrong with the SQL server, could it be a problem with the IIS server it connects to

Any suggestions would be greatly appreciated
Thanks in advance

Hi:
As I knowledge, most bug is caused by the code yourself and you have the
call stack, you can see where the error happen is
[quoted text, click to view]
c:\inetpub\wwwroot\aifl-na\Secure\downloadReadingAssessment2.aspx.vb:line
247

I suggest you insert a breakpoint at line 247 for
downloadReadingAssessment2.aspx.vb, please check the status at that line and
you may ask in the vb groupnews, because it is not exeception throws by sql
server, after I search in MSDN, it is not error can can handle in vs.net :)

Best Wishes
Wei Ci Zhou

You might try running a network monitor trace to see what is going on on
the network when this problem occurs.

Rand
This posting is provided "as is" with no warranties and confers no rights.