🚀 go-pugleaf

Dan,

We are having the same problem using Access 95 as a front-end to SQL 6.5
SP2 running on NT 3.51 SP4.  The app has 10-12 users in the home office and
works great - the 3-4 users in the remote office experience 5-7 second
delays pulling up 500 byte records over the 56K frame relay link.  Database
connectivity is through ODBC.  I have noticed monitoring the traffic that
the ODBC layer results in dozens of lines of traffic for even the simplest
transaction.

Any ways to speed it up?????

Thanks,

Harley 

Dan Armstrong <dana@rogers.wave.ca> wrote in article
<331F1A1E.4F99@rogers.wave.ca>...
> 
> Are you using IP Sockets, or Named Pipes over Netbios over IP?  The
> Netbios over IP scenario can be really messy over WAN links, as the
> routers must do all sorts of nasty broadcast-spoofing.  Cisco's happen
> to be very good at this stuff...Try using IP sockets, if not are you
> using WINS/NBNS on the NT Servers?  We have an SQL server that we access
> through a 56K link, and properly architected it can run very smoothly,
> like there is no WAN at all.  
> 
> Another thing to look for is ODBC.  It tends to turn a simple 100 byte
> query into pages of crap, are you using ODBC?
> 
> Dan.
>