I am not a real expert on VPN or such, and am sure that your Internet connection speed has a major impact. Try pinging your server over the VPN with a -T option and see how many time outs you are getting. If several time outs are seen or if you see a lot of reply times over 150 your connection is suspect for decent DSL. (command line - ping "server ip address" -t) Another thing that I have found that may be of some use is the sequence in which you exit the software and then close the VPN.
One thing to try as a test is when you exit Rbase on the VPN, either conduct some other file operation or wait a period of time before closing the VPN. I have found that when my user closes the software linked to RBASE through ODBC and then closes the VPN immediately, I see the sync problem almost everytime. If they wait a few minutes or conduct some other file operation, the problem seems to go away. It almost seems like a buffer is not being purged quickly enough. So as a test, connect VPN, open Rbase, do some stuff, then exit Rbase and immediately disconnect the VPN and see if you get the sync problem. Then conduct the above only do a small file copy or wait a few minutes between closing Rbase and disconnecting the VPN. If the problem does not show itself, you may have at least have partially found the issue. You may have to do the above a few times to verify the case.
-Bob
I keep meaning to do some research on the situation, but as with most, I have been very busy and since the problem is controllable for the time being, I have not done so.
-------------- Original message --------------
> Bob,
>
> That's very interesting. When I work from home I am on VPN but here in the
> office, I'm simply on the network. RB4 seems to be the file most often out
> of sync. What should I ask my hardware guys to check??
>
> Claudine
>
> ________________________________________
> From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of
> [EMAIL PROTECTED]
> Sent: Tuesday, March 08, 2005 3:59 PM
> To: RBG7-L Mailing List
> Subject: [RBG7-L] - Re: rbsync
>
> Claudine,
> I have never had a database go out of sync unless one of two things
> happened...
>
> 1) An abnormal exit such as a power loss, tripped over power cable, etc. or
> network related exit such as switch problems or a cable coming unplugged.
>
> 2) VPN's might frequently cause sync problems. If you are running over a
> VPN, I have seen the files get a time stamp difference during normal exit.
> I believe the RB1 file gets closed last and sometimes a delay in the VPN
> seems to cause it to get a slightly later date stamp. I have one case where
> a database gets accessed via an ODBC connection over a VPN and I see the
> sync problem occasionally with no other apparent errors or problems.
>
> So if you have anything running over a VPN, I would bet that may be where
> the problem lies. If not, then you probably have a bad network component
> somewhere.
>
> -Bob
>
> -------------- Original message --------------
>
> > Both my databases are continually out of sync even though I have AUTOSYNC
> ON
> > in my rbase.dat file. I have reported this and have never had an
> explanation
> > as to why this happens. Several times a week, I unload and recreate both
> > db's so there is no corruption involved, I don't think.
> >
> > ________________________________________
> > From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of Dennis
> Fleming
> > Sent: Tuesday, March 08, 2005 1:24 PM
> > To: RBG7-L Mailing List
> > Subject: [RBG7-L] - Re: rbsync
> >
> > I had a customer where they had some network NIC problems and eventually I
>
> > had the RBSYNC as AUTOSYNC ON in the RBase config file. It worked, but you
>
> > are probably masking a problem where one or more user updates are not
> > getting the four RBfiles updated and time stamped properly. I.e., you
> could
> > be overlooking database corruption.
> >
> > Dennis
> > *****
> >
> >
> > At 01:00 PM 3/8/2005, you wrote:
> >
> > Anyone,
> >
> > Where is the best place to put RBSYNC? Exiting or Connecting?
> >
> > Thanks.
> >
> > Deb Roepken
> > cmri
> > 631-587-1495
> >
> >
> >
>
