computer sleep and db connections

[Brian Henry]

How would you guys handle this? We have an app that needs to keep an open
connection to a SQL 2000 Server, (no it cant be disconnected because of what
we are doing uses it so frequently, its a waste to constantly connect and
disconnect every other second littearly)... but we have some systems which
seem to go into sleep mode on their NIC even when we have power managment
turned off after so long (long running problem with some of our HP
workstations and their NIC's) so even though windows doesn't sleep and the
system doesnt sleep, the NIC still goes into a low power state sometimes
after the system sits idle for so long... then when you come back a "General
network error" has occured because it lost the connection... now in .NET 2.0
there is a function to handle a network disconnect like this, but what would
you do in .NET 1.1? which is what we are still useing until .NET 2.0 is a
stable release. thanks

 

[Armin Zingler]

How would you guys handle this? We have an app that needs to keep an
open connection to a SQL 2000 Server, (no it cant be disconnected
because of what we are doing uses it so frequently, its a waste to
constantly connect and disconnect every other second littearly)...
but we have some systems which seem to go into sleep mode on their
NIC even when we have power managment turned off after so long (long
running problem with some of our HP workstations and their NIC's) so
even though windows doesn't sleep and the system doesnt sleep, the
NIC still goes into a low power state sometimes after the system
sits idle for so long... then when you come back a "General network
error" has occured because it lost the connection... now in .NET 2.0
there is a function to handle a network disconnect like this, but
what would you do in .NET 1.1? which is what we are still useing
until .NET 2.0 is a stable release. thanks

Have a look @ one of these groups for language unrelated questions:
microsoft.public.dotnet.framework.*


Armin