Slow SQL Connection with Wireless

Posted on 2006-05-18
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
    LVL 48

    Accepted Solution

    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

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

    Expert Comment

    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

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    How to run any project with ease

    Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
    - Combine task lists, docs, spreadsheets, and chat in one
    - View and edit from mobile/offline
    - Cut down on emails

    A brief overview to explain gateways, default gateways and static routes OR NO - you CANNOT have two default gateways on the same server, PC or other Windows-based network device. In simple terms a gateway is formed when a computer such as a serv…
    The Need In an Active Directory enviroment, the PDC emulator provide time synchronization for the domain. This is important since Active Directory uses Kerberos for authentication.  By default, if the time difference between systems is off by more …
    It is a freely distributed piece of software for such tasks as photo retouching, image composition and image authoring. It works on many operating systems, in many languages.
    Migrating to Microsoft Office 365 is becoming increasingly popular for organizations both large and small. If you have made the leap to Microsoft’s cloud platform, you know that you will need to create a corporate email signature for your Office 365…

    759 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

    Need Help in Real-Time?

    Connect with top rated Experts

    10 Experts available now in Live!

    Get 1:1 Help Now