Hi All,

i have an asp.net application which has got sql server 2000 behind the
scenes.
Very simple application, all it does is extract the data from the databse
and display it in the grid. But randomly when i access my website in
productin ,i get this error mentioned below but when it hit on refresh the
website comesup. My website is hosted with godady and they told me that they
jsut can not replciate the error on there side and which they are right, as
it is really sporadic. Does any body have any idea out there as to what might
he happening here. Seems it is happening when my object PRODUCTDB call the
method GetMostPopularProductsOfWeek() which has an executereader menthod
which get the data from the database. Any suggestion is more than welcome.

thanks


================================================== ========================================

Server Error in '/' Application
--------------------------------------------------------------------------------

General network error. Check your network documentation.
Description: An unhandled exception occurred during the execution of the
current web request. Please review the stack trace for more information about
the error and where it originated in the code.

Exception Details: System.Data.SqlClient.SqlException: General network
error. Check your network documentation.

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:


[SqlException: General network error. Check your network documentation.]
System.Data.SqlClient.SqlCommand.ExecuteReader(Com mandBehavior
cmdBehavior, RunBehavior runBehavior, Boolean returnStream) +742
System.Data.SqlClient.SqlCommand.ExecuteReader(Com mandBehavior behavior)
+45
IBuySpy.IBuySpy.ProductsDB.GetMostPopularProductsO fWeek()
IBuySpy.CDefault.Page_Load(Object sender, EventArgs e)
System.Web.UI.Control.OnLoad(EventArgs e) +67
System.Web.UI.Control.LoadRecursive() +35
System.Web.UI.Page.ProcessRequestMain() +750




--------------------------------------------------------------------------------
Version Information: Microsoft .NET Framework Version:1.1.4322.2032; ASP.NET
Version:1.1.4322.2032

================================================== =========================================

Not at all sure, but I guess this is one of those try-all to catch error
issues ;-) Anyway, you say this is sporadic, but have you tried replicating
by executing the GetMostPopularProductsOfWeek method several times at the
same time or in close succession?

--
Carsten Thomsen
Enterprise Development with VS .NET, UML, AND MSF
http://www.apress.com/book/bookDisplay.html?bID=105

"sameer" <sameer (AT) discussions (DOT) microsoft.com> wrote