This is a multi-part message in MIME format.
------=_NextPart_000_0076_01C485C4.9954EB20
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
We are having some major issues with supisuous errors while using =
Biztalk that we beleive may be linked to network issues or possibly a =
bad NIC. So we wrote a small app to continuously "ping" - really it =
issues a small select against a table - the DB every 2 seconds. We had =
lots of errors crop up doing this. In doing so seemed to narrow some =
issues down to ADO.NET's pooling along with problems in teh network. =
Appearently if there were network issues and the pooled connection got =
"hosed", the whole connection was doomed and we'd recieve errors =
"General network errors" on the next attempt to use the hosed =
connection.
Now, we have disabled pooling and getting the below exception. Does =
anyone know what normally causes this exception to occur out of the =
"OpenAndLogin" method?
Kevin
-------------------------------------------------------------------------=
-------
Event Type: Error
Event Source: DatabasePing
Event Category: None
Event ID: 0
Date: 8/18/2004
Time: 6:04:35 PM
User: N/A
Computer:=20
Description:
System.Data.SqlClient.SqlException: General network error. Check your =
network documentation.
at System.Data.SqlClient.SqlInternalConnection.OpenAndLogin()
at System.Data.SqlClient.SqlInternalConnection..ctor(SqlConnection =
connection, SqlConnectionString connectionOptions)
at System.Data.SqlClient.SqlConnection.Open()
at DatabasePing.DatabasePing._IssueSelect(String query, String =
connectionString)
at DatabasePing.DatabasePing._IssuePing(Object stateInfo)
For more information, see Help and Support Center at =
http://go.microsoft.com/fwlink/events.asp.
------=_NextPart_000_0076_01C485C4.9954EB20
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=3DContent-Type content=3D"text/html; =
charset=3Diso-8859-1">
<META content=3D"MSHTML 6.00.2800.1276" name=3DGENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY>
<DIV><FONT face=3DVerdana size=3D2>We are having some major issues with =
supisuous=20
errors while using Biztalk that we beleive may be linked to network =
issues or=20
possibly a bad NIC. So we wrote a small app to continuously "ping" =
-=20
really it issues a small select against a table - the DB =
every 2=20
seconds. We had lots of errors crop up doing this. In =
doing so=20
seemed to narrow some issues down to ADO.NET's pooling along with =
problems=20
in teh network. Appearently if there were network issues and the =
pooled=20
connection got "hosed", the whole connection was doomed and we'd recieve =
errors=20
"General network errors" on the next attempt to use the hosed=20
connection.</FONT></DIV>
<DIV><FONT face=3DVerdana size=3D2></FONT> </DIV>
<DIV><FONT face=3DVerdana size=3D2>Now, we have disabled pooling and =
getting the=20
below exception. Does anyone know what normally causes this =
exception to=20
occur out of the "OpenAndLogin" method?</FONT></DIV>
<DIV><FONT face=3DVerdana size=3D2></FONT> </DIV>
<DIV><FONT face=3DVerdana size=3D2>Kevin</FONT></DIV>
<DIV><FONT face=3DVerdana size=3D2></FONT> </DIV>
<DIV><FONT face=3DVerdana size=3D2>
<HR>
</FONT></DIV>
<DIV><FONT face=3DVerdana size=3D2></FONT> </DIV>
<DIV><FONT face=3DVerdana size=3D2>Event Type: Error<BR>Event=20
Source: DatabasePing<BR>Event Category: None<BR>Event=20
ID: 0<BR>Date: 8/18/2004<BR>Time: 6:04:35=20
PM<BR>User: N/A<BR>Computer: <BR>Description:<BR>System.D=
ata.SqlClient.SqlException:=20
General network error. Check your network =
documentation.<BR> =20
at =
System.Data.SqlClient.SqlInternalConnection.OpenAndLogin()<BR>  =
; at=20
System.Data.SqlClient.SqlInternalConnection..ctor(SqlConnection =
connection,=20
SqlConnectionString connectionOptions)<BR> at=20
System.Data.SqlClient.SqlConnection.Open()<BR> at=20
DatabasePing.DatabasePing._IssueSelect(String query, String=20
connectionString)<BR> at =
DatabasePing.DatabasePing._IssuePing(Object=20
stateInfo)</FONT></DIV>
<DIV><FONT face=3DVerdana size=3D2>For more information, see Help and =
Support Center=20
at </FONT><A href=3D"http://go.microsoft.com/fwlink/events.asp"><FONT =
face=3DVerdana=20
size=3D2>http://go.microsoft.com/fwlink/events.asp</FONT></A><FONT =
face=3DVerdana=20
size=3D2>.<BR></FONT></DIV></BODY></HTML>
------=_NextPart_000_0076_01C485C4.9954EB20--