While we are on this subject, just FYI, here is a snippet of code I got
from this list a while back and has saved me from the dreaded out of
sync messages which were getting frequent. I suspect there was caching
on the server and this was causing some weirdness that was getting worse
and worse, the DB was going out of sync about once every couple weeks at
night during or after a server backup. I THINK it works in 6.5++, maybe
Razzak or John can confirm it. Since I have converted 90% of my apps to
7.5 I'm not sure if AUTOSYNC was supported then. I added this to my dat
file and haven't had any problems for a year:
SET AUTOSYNC ON
CONNECT <path and database name>
IF SQLCODE IN (1212,1213,1214,-2520) THEN
RBSYNC <databasename> EXECUTE
CONNECT <path and database name>
ENDIF
Regards,
Bob C
-----Original Message-----
From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of Susan
Seelye
Sent: Thursday, June 22, 2006 2:20 PM
To: RBASE-L Mailing List
Subject: [RBASE-L] - Re: DB out of sync
Thank You!
----- Original Message -----
From: "A. Razzak Memon" <[EMAIL PROTECTED]>
To: "RBASE-L Mailing List" <[email protected]>
Sent: Thursday, June 22, 2006 12:51 PM
Subject: [RBASE-L] - Re: DB out of sync
> At 12:40 PM 6/22/2006, you wrote:
> >Hi,
> >I am running 6.5++.
> >When trying to connect I get the following error:
> >DB is out of sync
> >I am unable to connect.
> >
> >Could someone please tell me how to fix this?
>
> Susan,
>
> Here's how:
>
> At the R> prompt:
>
> DISCONNECT
> RBSYNC dbname EXECUTE
>
> That will re-sync the database accordingly.
>
> That's all there is to it!
>
> Very Best R:egards,
>
> Razzak.
>
>
