Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2007-03-12 : 09:22:01
|
| Jimmy writes "We use a software that stores its database in SQL. We currently have a server box running Windows 2000 Server with SP4 and SQL Server 2005 with SP2 which holds the database. The server is wired in but we have several other stations that connect to the database wirelessly. The problem is with our wireless stations.When a wireless client travels from one access point to a repeater, it'll drop the connection for that moment. Once it picks up the wireless connection again, it requires closing out of the software and going back into it so it reestablishes the SQL connection to the server.Is there a solution for a seamless reconnection with SQL for our wireless clients? Is this a problem with our software or SQL? Please advise. Thank you." |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2007-03-12 : 14:17:33
|
| It's a problem with your software and not SQL Server. The software will need to be modified to fix this.Tara Kizer |
 |
|
|
JimVWilliams
Starting Member
7 Posts |
Posted - 2007-04-02 : 18:17:17
|
| Sounds more like a config issue with your wireless network.Simple answer is to try your software with a non-wireless connection for a day or two. If you hit no problems, it's probably your network, NOT the software. Never heard anything like this with SQL Server, have regularly used it with Buffalo and NetGear wireless kit for a couple of years, no problems.Jim. |
|
|
|
|
|
|
SQL in a wireless environment