occasional SqlException 'a severe error occured...'

[Sven Schimmel]

Hello all,

I face the problem that occasional in one WebApplication
the following error occures:

System.Data.Sql Client.SqlExcep tion: A severe error
occurred on the current command. The results, if any,
should be discarded.
at System.Data.Sql Client.SqlComma nd.ExecuteNonQu ery()
at ASP.AnbieterDet ail_ascx.WriteL og(String StrID,
String StrKat) in
C:\Inetpub\wwwr oot\LNO_live\us ercontrols\Anbi eterDetail.asc
x:line 38

This error occures also occasionaly on other Usercontrols,
in which the SQLServer is accessed. The problem is, that I
can not reproduce the error. Sometimes it works and
sometimes not, with the same data in the webform.
Other Applications with the same basic Architecture do not
have this problem.
I looked arround in the internet and saw that a few others
face a similar problem.

The Application runs on the Webserver with
Windows2000Adva ncedServer installed and The Database on a
Databaseserver also with Windows200Advan cedServer
installed and SqlServer2000.

If there is any solution to my problem, or if you need
more information just let me know.

Thanks a lot.

Sven

[CT]

Sven,

What does the SQL statement do? Are you working with Stored Procedures? Are
you doing any row locking (implicit or explicit) that might cause an update,
insert or deltion to fail?

--
Carsten Thomsen
Enterprise Development with Visual Studio .NET, UML, and MSF
http://www.apress.com/book/bookDisplay.html?bID=105
"Sven Schimmel" <Sv************ ******@hotmail. com> wrote in message
news:0a******** *************** *****@phx.gbl.. .

Hello all,

I face the problem that occasional in one WebApplication
the following error occures:

System.Data.Sql Client.SqlExcep tion: A severe error
occurred on the current command. The results, if any,
should be discarded.
at System.Data.Sql Client.SqlComma nd.ExecuteNonQu ery()
at ASP.AnbieterDet ail_ascx.WriteL og(String StrID,
String StrKat) in
C:\Inetpub\wwwr oot\LNO_live\us ercontrols\Anbi eterDetail.asc
x:line 38

This error occures also occasionaly on other Usercontrols,
in which the SQLServer is accessed. The problem is, that I
can not reproduce the error. Sometimes it works and
sometimes not, with the same data in the webform.
Other Applications with the same basic Architecture do not
have this problem.
I looked arround in the internet and saw that a few others
face a similar problem.

The Application runs on the Webserver with
Windows2000Adva ncedServer installed and The Database on a
Databaseserver also with Windows200Advan cedServer
installed and SqlServer2000.

If there is any solution to my problem, or if you need
more information just let me know.

Thanks a lot.

Sven