sporadic db connection error

[sameer]

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 GetMostPopularP roductsOfWeek() 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.Sql Client.SqlExcep tion: 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.Sql Client.SqlComma nd.ExecuteReade r(CommandBehavi or
cmdBehavior, RunBehavior runBehavior, Boolean returnStream) +742
System.Data.Sql Client.SqlComma nd.ExecuteReade r(CommandBehavi or behavior)
+45
IBuySpy.IBuySpy .ProductsDB.Get MostPopularProd uctsOfWeek()
IBuySpy.CDefaul t.Page_Load(Obj ect sender, EventArgs e)
System.Web.UI.C ontrol.OnLoad(E ventArgs e) +67
System.Web.UI.C ontrol.LoadRecu rsive() +35
System.Web.UI.P age.ProcessRequ estMain() +750


--------------------------------------------------------------------------------
Version Information: Microsoft .NET Framework Version:1.1.432 2.2032; ASP.NET
Version:1.1.432 2.2032

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

[Bruce Barker]

its just a standard network error. you should catch and retry.

-- bruce (sqlwork.com)

"sameer" <sa****@discuss ions.microsoft. com> wrote in message
news:65******** *************** ***********@mic rosoft.com...

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 GetMostPopularP roductsOfWeek() 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.Sql Client.SqlExcep tion: 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.Sql Client.SqlComma nd.ExecuteReade r(CommandBehavi or
cmdBehavior, RunBehavior runBehavior, Boolean returnStream) +742
System.Data.Sql Client.SqlComma nd.ExecuteReade r(CommandBehavi or behavior)
+45
IBuySpy.IBuySpy .ProductsDB.Get MostPopularProd uctsOfWeek()
IBuySpy.CDefaul t.Page_Load(Obj ect sender, EventArgs e)
System.Web.UI.C ontrol.OnLoad(E ventArgs e) +67
System.Web.UI.C ontrol.LoadRecu rsive() +35
System.Web.UI.P age.ProcessRequ estMain() +750


--------------------------------------------------------------------------------
Version Information: Microsoft .NET Framework Version:1.1.432 2.2032;
ASP.NET
Version:1.1.432 2.2032

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

[sameer]

thanks Bruce, i will try that, but the question is why does it happen on the
first place.

"Bruce Barker" wrote:

its just a standard network error. you should catch and retry.

-- bruce (sqlwork.com)

"sameer" <sa****@discuss ions.microsoft. com> wrote in message
news:65******** *************** ***********@mic rosoft.com...

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 GetMostPopularP roductsOfWeek() 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.Sql Client.SqlExcep tion: 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.Sql Client.SqlComma nd.ExecuteReade r(CommandBehavi or
cmdBehavior, RunBehavior runBehavior, Boolean returnStream) +742
System.Data.Sql Client.SqlComma nd.ExecuteReade r(CommandBehavi or behavior)
+45
IBuySpy.IBuySpy .ProductsDB.Get MostPopularProd uctsOfWeek()
IBuySpy.CDefaul t.Page_Load(Obj ect sender, EventArgs e)
System.Web.UI.C ontrol.OnLoad(E ventArgs e) +67
System.Web.UI.C ontrol.LoadRecu rsive() +35
System.Web.UI.P age.ProcessRequ estMain() +750


--------------------------------------------------------------------------------
Version Information: Microsoft .NET Framework Version:1.1.432 2.2032;
ASP.NET
Version:1.1.432 2.2032

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

[Bruce Barker]

networks are not always reliable. ask you isp why you are getting network
errors. what is your service level agreement? (a couple hundred a day may
be normal for them). they may be getting broadcast storms, or doing dynamic
reconfiguration .

-- bruce (sqlwork.com)
"sameer" <sa****@discuss ions.microsoft. com> wrote in message
news:DE******** *************** ***********@mic rosoft.com...

thanks Bruce, i will try that, but the question is why does it happen on
the
first place.

"Bruce Barker" wrote:

its just a standard network error. you should catch and retry.

-- bruce (sqlwork.com)

"sameer" <sa****@discuss ions.microsoft. com> wrote in message
news:65******** *************** ***********@mic rosoft.com...

>
> 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 GetMostPopularP roductsOfWeek() 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.Sql Client.SqlExcep tion: 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.Sql Client.SqlComma nd.ExecuteReade r(CommandBehavi or
> cmdBehavior, RunBehavior runBehavior, Boolean returnStream) +742
> System.Data.Sql Client.SqlComma nd.ExecuteReade r(CommandBehavi or
> behavior)
> +45
> IBuySpy.IBuySpy .ProductsDB.Get MostPopularProd uctsOfWeek()
> IBuySpy.CDefaul t.Page_Load(Obj ect sender, EventArgs e)
> System.Web.UI.C ontrol.OnLoad(E ventArgs e) +67
> System.Web.UI.C ontrol.LoadRecu rsive() +35
> System.Web.UI.P age.ProcessRequ estMain() +750
>
>
>
>
> --------------------------------------------------------------------------------
> Version Information: Microsoft .NET Framework Version:1.1.432 2.2032;
> ASP.NET
> Version:1.1.432 2.2032
>
> =============== =============== =============== =============== =============== =============== =