Fatal Connection Error

[JW]

I catching these exceptions and the see odd especially since I have my web
and SQL server connected directly to each other via a second nic card on a
private network address... Any ideas would be helpful.

SELECT CompanyName FROM Affiliates WHERE AffiliateID=173 --->
System.InvalidOperationException: Internal connection fatal error.


Josiah

 

[Miha Markic]

Hi JW,

I would say that you have some connection problems, maybe hardware ones.
IOW I don't think it is related to software and almost certainly not to
..net.
Does it happen often?
Is reproducable?

 

[supasunshine]

I am getting the same error. It is sporadic, about once every 20
times and occurs in numerous places. It is always with the
System.Data.SqlClient, and I get it with the ExecuteReader,
TdsParser,ExecuteTransaction commands.

Has anyone seen this? I suspect it's a network issue, but have not
been able to prove this. I created a page which does a simple update
and select statement attempting to get the invalid connection fatal
error. It did not work, which makes me suspect it being a code
issue. The issue happens in one environment, but not another.

Any assistance would be greatly appreciated.
Thanks!