Timeout when connection to SQL Server in WiFi LAN
Help required Urgently.
Timeout issue when connection to SQL Server in Wireless environment:
I am having problems with long timeouts when connecting to
or executing commands in SQL Server(MSDE 2000). I am
writing an application that will be used on laptops within
an environment that is wireless. The application is
written in VB6 using ADO 2.6.
I have set the "Connect Timeout" parameter on the
connection string to 180 seconds and whenever I execute a
command, I set the CommandTimeout property to 180 seconds
on the command object.
When I open a connection where there is poor signal
strength or I am in a dead spot, I have timed the various
timeouts the Open method gives me on the connection to be
anywhere between 25 seconds to 70 seconds. Similiar
results with sending commands.
Any help or experiences in this type of environment would be
appreciated.
Thanks,
SMP
|