ADO over WAN

Has anyone successfully run a client/server application connected to a SQL
Server over WAN with good performance? Over LAN environment our query takes
4 seconds, but over WAN it takes about 3 minutes. Of course, this could be a
physical limitation, but I am curious if it's even possible to make this
work.

Morten


.

Relevant Pages

  • Re: Site Server Requirements.
    ... availability must be able to operate independently; if the WAN link is ... Your requirements are driving much of the design. ... I didn't comprehend what the second server per site was for, ... sites use NT Workgroups for critical server authentication and will not be ...
    (microsoft.public.windows.server.active_directory)
  • Re: Is UserLevel Security Really Necessary?
    ... read-write database. ... use over a WAN. ... client application to a server DB at a central site ... security considerations will be different. ...
    (comp.databases.ms-access)
  • Re: TCP Window Size
    ... terminal server, so window size wouldn't be the problem. ... network I/O, active clients, etc. ... Multiple parallel WAN links are being load ...
    (comp.dcom.sys.cisco)
  • Re: server lockup issue - narrowed down
    ... to delete the extra wan miniports installed i had to ... I used devcon.exe to reinstall the wan miniport and once that was done, ... works fine from clients and server. ... You cannot start the Routing and Remote Access service on a Windows 2000 ...
    (microsoft.public.windows.server.sbs)
  • Re: Two Server Implementation using Exchange 2003 Standard
    ... We have to establish the WAN to support our primary ... The LA users use Citrix Terminal Service Client to ... their Inbox until it arrives at their server... ...
    (microsoft.public.exchange.setup)