sql server connect: Notification on lost connection. -- sql server connect

Notification on lost connection.

Peter Ericsson
3/31/2005 12:15:11 AM

sql server connect:

How do I detect that my C# application has lost the
connection to the SQL Server. The reason for the lost
connection is that the network connection is down.

Changing the "connection timeout" property in the
connection string only helps when I have a connection to
the server that the SQL server is running on.

Is there a solution that doesn't use polling of the SQL

Re: Notification on lost connection.

Vikram Vamshi
3/31/2005 6:39:23 PM

Could you not simply handle the exception that you get when opening a sql
connection (if the network is down)?
Are you trying to open up a persistent connection to SQL Server and then
monitor the state of the connection?
--
Vikram Vamshi
Eclipsys Corporation
[quoted text, click to view]