Quickbooks over VPN? Archive – Micro Focus Forums #operations, #work, #quickbooks, #long,


#

05-Apr-2005, 07:16 PM

I recently set up our new accountant with the BM vpn and NW clients so that
she might be able to access our quickbooks 2000 database via a mapped drive
while connected to our BM3.7 server. She can connect fine, and althought QB
(a known resource hog) is fairly slow for most common operations over the
vpn (both client and server have SDSL connections over 500kbps), it is not
entirely unworkable. SOME particular operations, however, take an
IMPOSSIBLY long time (especially find operations in the records DB),
literally many, many orders of magnitude slower than everything else.

Is this really just due to the number of drive accesses involved in these
operations, or is there some other buggy issue at work here?

Does anyone know how to troubleshoot/work around this problem effectively?
We are really trying to avoid having to shutdown/lock the QB system long
enough for our accountant to copy the DB to a local machine, do her work,
and then write it back out to our system. We really need a way for her to
be able to work remotely AND concurrently with the rest of us.

Many, many thanks in advance for any help.

06-Apr-2005, 04:26 PM

You will probably need to take some traces (Ethereal on the PC’s
involved) to see what kind of traffic is involved. Might be as simple
as needing to reduce MTU size on one or both ends of that connection.

Perhaps simpler would be to use pcANYWHERE, VNC or terminal server/RDP
to remote control an internal PC over the VPN to do the work remotely.

Craig Johnson
Novell Support Connection SysOp
*** For a current patch list, tips, handy files and books on
BorderManager, go to http://www.craigjconsulting.com ***

06-Apr-2005, 04:33 PM

My experience with Quickbooks over a lan is that the newer versions can be a
little slow as it is. I would venture to say that there is just way too
much data to push through that small DSL pipe.

14-Apr-2005, 04:07 PM

Thanks for the input Craig and JP,

I apologize for my own sluggish response. I actually found a post on
another site that echoed Craig’s suggestion of running quickbooks on a local
machine and having the remote client connect to it using pcAnywhere or the
like so that all the heavy drive accesses remain local. I’m going to give
that a try.

Thanks again for the help,