Hi,

I am occasionally getting the above error from an ASP.NET application that i
nserts documents into a SQL database. It had been running without this probl
em for several months and suddenly this problem has raised it's head twice i
n 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 execute
d 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.HttpUnhandle
dException was thrown. ---> System.Data.SqlClient.SqlException: General netw
ork error. Check your network documentation.
at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior cmdBehavio
r, 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 247
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+IExecution
Step.Execute()
at System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& comp
letedSynchronously)

The only way Ihave managed to stop this happening is to restart the IIS serv
er that connects to the database. As far as I can tell there is nothing wron
g 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,
Alistair Gillespie

[ Post a follow-up to this message ]

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
quote:

> at aifl_na.downloadReadingTest2.Page_Load(Object sender, EventArgs e) in

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

[ Post a follow-up to this message ]

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.

[ Post a follow-up to this message ]