Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium


Slow SQL Connection with Wireless

Posted on 2006-05-18
Medium Priority
Last Modified: 2012-06-27
Have Win03 and SQL 2000 setup and running.  Use a Program Called Macola ES to access the database and also a few ASP pages I have writen.  Data is taking a long time to come from the database, and causes the tables to lock and timeout.  There is one location that uses the Macola ES program from a wireless USB Network card and that one takes 2x-3x as long as the PCs on the normal LAN to process an item.  Any issues, or ideas that we can try to speed up SQL Server or the workstation's link to SQL via Wireless?  The other Wireless locations are only accessing an ASP page witch is slow also, and times-out if the other PC locks the table.
Question by:kwitcom
  • 2
LVL 48

Accepted Solution

Jay_Jay70 earned 1500 total points
ID: 16713519
Hi kwitcom,

accessing SQL like this over a wireless link isnt exactly an ideal setup..... Wireless speeds are much slower than wires and the drop out rate can be high

are you saying you have a machine on a wireless link that does work well?

Author Comment

ID: 16717447
Yes.... Is there anything to help with SQL connection?
LVL 48

Expert Comment

ID: 16718109
no, due to the instability of wireless itself, unless you are saying that there is a box accessing SQL that works fine, then there is other issues to look at

Featured Post

Restore individual SQL databases with ease

Veeam Explorer for Microsoft SQL Server delivers an easy-to-use, wizard-driven interface for restoring your databases from a backup. No expert SQL background required. Web interface provides a complete view of all available SQL databases to simplify the recovery of lost database

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

I'm a big fan of Windows' offline folder caching and have used it on my laptops for over a decade.  One thing I don't like about it, however, is how difficult Microsoft has made it for the cache to be moved out of the Windows folder.  Here's how to …
This article offers some helpful and general tips for safe browsing and online shopping. It offers simple and manageable procedures that help to ensure the safety of one's personal information and the security of any devices.
Michael from AdRem Software explains how to view the most utilized and worst performing nodes in your network, by accessing the Top Charts view in NetCrunch network monitor (https://www.adremsoft.com/). Top Charts is a view in which you can set seve…
As many of you are aware about Scanpst.exe utility which is owned by Microsoft itself to repair inaccessible or damaged PST files, but the question is do you really think Scanpst.exe is capable to repair all sorts of PST related corruption issues?

580 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question