Sproadic ADO.NET Error

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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(CommandBehavior
cmdBehavior, RunBehavior runBehavior, Boolean returnStream) +742
System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior)
+45
IBuySpy.IBuySpy.ProductsDB.GetMostPopularProductsOfWeek()
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
 
Sounds to me like problem with communication to sql server - perhaps their
network "flips" sometimes.

--
Miha Markic [MVP C#] - RightHand .NET consulting & development
www.rthand.com
Blog: http://cs.rthand.com/blogs/blog_with_righthand/
SLODUG - Slovene Developer Users Group www.codezone-si.info

sameer said:
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(CommandBehavior
cmdBehavior, RunBehavior runBehavior, Boolean returnStream) +742
System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior)
+45
IBuySpy.IBuySpy.ProductsDB.GetMostPopularProductsOfWeek()
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

===========================================================================================
Click to expand...
 
Are you executing stored procedures? Could those procedures fail with a
severity code high enough to close the connection at the server end?

--
____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant
Microsoft MVP
www.betav.com/blog/billva
www.betav.com
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
__________________________________

sameer said:
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(CommandBehavior
cmdBehavior, RunBehavior runBehavior, Boolean returnStream) +742
System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior)
+45
IBuySpy.IBuySpy.ProductsDB.GetMostPopularProductsOfWeek()
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

===========================================================================================
Click to expand...
 
but then the question is why does it come back right after when i click on
REFRESH, if it is a network issue then it should take must longer.


Miha Markic said:
Sounds to me like problem with communication to sql server - perhaps their
network "flips" sometimes.

--
Miha Markic [MVP C#] - RightHand .NET consulting & development
www.rthand.com
Blog: http://cs.rthand.com/blogs/blog_with_righthand/
SLODUG - Slovene Developer Users Group www.codezone-si.info

sameer said:
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(CommandBehavior
cmdBehavior, RunBehavior runBehavior, Boolean returnStream) +742
System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior)
+45
IBuySpy.IBuySpy.ProductsDB.GetMostPopularProductsOfWeek()
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

===========================================================================================
Click to expand...
Click to expand...
 
Hello Miha Markic

I think you should close datareader before closing connection.
Write proper clean up code.

regards
bhawin13
 
Back
Top