If your user is out driving around the cemetary, the connection may drop in various spots, but be fine ten feet away. You need to handle dropped connections by trying to reconnect.
>Accessing SQL Server over the internet/VPN using ODBC seems to be an accepted practice and reliable enough. What's the word on wireless LANs? We tell our clients in no uncertain terms not to access FoxPro data over a wireless network. It inevitably leads to data corruption. My expectation is that SQL Server will enable using a wireless network, but what is your experience?
>
>Thanks.
Craig Berntson
MCSD, Microsoft .Net MVP, Grape City Community Influencer