Re: ADO parameters queries and stored procedures - and Connections

On Mon, 25 Jul 2005 22:58:02 -0400, "Darryl Kerkeslager"
<kerkeslager@xxxxxxxxxxx> wrote:

>Steve Jorgensen wrote:
>> The only reason to
>> disconnect is if you really do want to close the connection to conserve
>> resources.
>
>I'm doing this over a WAN (The Powers said I couldn't use their SQL Server).
>All I want to accomplish is make it faster, any way I can. The WAN is good
>and fast, and the PCs and server involved are first rate. I just want to:
>
>1. Not open and close the connection if preventable - this alone takes
>anywhere from 1-2 seconds, so if I open and close a recordset 4 times
>instead of 1 in one Save action, that's an extra 3-6 seconds I add.
>
>2. Not send any more data TO the server than I need to to GET data.

I didn't realize you were using an Access MDB over a WAN. That's generally
both slow and unreliable. Can you get set up to remote control your PC at
work via Terminal Services? Alternatively, if there are only a handfull of
simultaneous users, could you use MSDE on your computer, and access that over
the WAN?

If none of those is an option, perhaps, you should look into replication.
David Fenton may have some advice on this point.
.

Relevant Pages

  • Re: terminal services disconnects
    ... WAN ... LAN side of the router and a gateway of the router IP address. ... the SBS server and see if the session is disconnected after 20-30 ... only get "TS connection has been broken" pop up. ...
    (microsoft.public.backoffice.smallbiz2000)
  • Re: terminal services disconnects
    ... It wasn't enough to interupt normal WAN ... LAN side of the router and a gateway of the router IP address. ... the SBS server and see if the session is disconnected after 20-30 minutes. ... only get "TS connection has been broken" pop up. ...
    (microsoft.public.backoffice.smallbiz2000)
  • Re: NIC Config, conflicts and changes
    ... just shows list of the New Connection, Local Area Server and then WAN. ... Panel and then my only options are WAN and Server Local Area Connection... ...
    (microsoft.public.windows.server.sbs)
  • problem with Routing & Remote Access
    ... Server has 2 NIC cards - one for LAN ... our MCSEs updated the NIC drivers on the server on Monday (both LAN and WAN ... connection into the network. ...
    (microsoft.public.backoffice.smallbiz2000)
  • Re: Outgoing POP3 email missing/lost/not received
    ... Funny thing is that I have had this ISP for 8 years and it has always been ... It looks like when you last ran CEICW, you set the ISP's mail server to: ... Internet Connection Wizard. ... After the wizard completes, the following network connection ...
    (microsoft.public.windows.server.sbs)