Link to home
Start Free TrialLog in
Avatar of kwitcom
kwitcomFlag for United States of America

asked on

Slow SQL Connection with Wireless

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.
ASKER CERTIFIED SOLUTION
Avatar of Jay_Jay70
Jay_Jay70
Flag of Australia image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of kwitcom

ASKER

Yes.... Is there anything to help with SQL connection?
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