kwitcom
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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
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
ASKER