Hi all The MS SQL client for SQL2005 does not seem to have an inbuilt auto-reconnect feature ? We have an app that connects to a remote SQL server which works fine on a wired connection but over wireless there seems to be no fault-tollerance at all. So the slightest blip on the Wifi connection and it falls over. How do other people get on with wifi networks updating SQL databases in a "desktop" type environment ? Thanks Andrew
It's a good idea to check the state of your connection before using it. That way if you do drop a connection you aren't thrown into your exception handling. Chuck Heinzelman "Andrew Kennard" wrote in message news:eltvuyB3IHA.5112@TK2MSFTNGP03.phx.gbl... > Hi all > > The MS SQL client for SQL2005 does not seem to have an inbuilt > auto-reconnect feature ? > > We have an app that connects to a remote SQL server which works fine on a > wired connection but over wireless there seems to be no fault-tollerance > at all. So the slightest blip on the Wifi connection and it falls over. > > How do other people get on with wifi networks updating SQL databases in a > "desktop" type environment ? > > Thanks > > Andrew > >
