Connection problems w/SQL Server & ADO.NET with WiFi

[David Gamble]

I am having problems with long timeouts when connecting to
or executing commands in SQL Server 2000 SP3. I am
writing an application that will be used on laptops within
an environment that is wireless. The application is
written in VB.NET using the SQL Server managed provider.

I have set the "Connect Timeout" parameter on the
connection string to 15 seconds and whenever I execute a
command, I set the CommandTimeout property to 15 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.

When I cannot open the connection I give the user the
ability to retry the operation that opens the database
connection after they have moved back into range. I
implemented this with a looping construct and messagebox
allowing the user to hit Retry or Cancel up to 5 tries
before it automatically cancels.

Sometime on the retry it will work, but sometimes the
second time through the loop to open the connection will
not work even if the laptop was moved back into range.

I am guessing that this behavior has to do with the
connection pooling combined with the fluctuating signal
strength and timing on the WiFi network. However, I have
been unable to find documentation or post in the
news/users groups that will help me with this issue. Any
help or experiences in this type of environment would be
appreciated.

Thanks,
Dave

 

[David Gamble]

Bill,
Thanks for the replay. This is for a pilot and in the long
term, we will have an architecture in place to cache and
store results locally. However, this behavior is of
interest becuase this could affect how we architect the
app.

Thanks,
Dave