Thanks, I'll use the nice little routine posted by Emmit.
BobC
| Albert Berry <[EMAIL PROTECTED]>
Sent by: [email protected] 06/27/2005 04:02 PM
|
|
Yes, it sure does. We have a 6.5++ startup script that sets it on because of sync problems just
before it connects.
--- Bob Castanaro <[EMAIL PROTECTED]> wrote:
> Does this autosync work in 6.5? I have a program that I haven't had time
> to upgrade and this has been an occasional problem with going out of sync
> overnight.
> BobC
>
>
>
>
> Emmitt Dove <[EMAIL PROTECTED]>
> Sent by: [email protected]
> 06/27/2005 01:35 PM
> Please respond to
> [email protected]
>
>
> To
> [email protected] (RBG7-L Mailing List)
> cc
>
> Subject
> [RBG7-L] - Re: cannot connect to database
>
>
>
>
>
>
>
> You could also do this in your startup file:
>
> SET AUTOSYNC ON
> CONNECT dbname
> IF SQLCODE IN (1212,1213,1214,-2520) THEN
> RBSYNC dbname EXECUTE
> CONNECT dbname
> ENDIF
>
>
> Neil,
>
> If this continues to occur it may indicate a network problem. Bad NIC,
> etc.
> You can check for the error on Connect, log it, and then RBsync the files.
> You can also change your RBase settings to:
>
> AUTOSYNC ON
>
> which will automatically sync (time stamp) your files if out of sync.
>
> I think the drawback with the later is it may be masking a deteriorating
> condition. I.e., syncing files which never were updated properly. Others
> on this list would know if Autosync On is a good idea.
>
> Dennis
> *****
>
> At 05:44 PM 6/21/2005, you wrote:
> It worked. Thank you.
>
> From: [email protected] [ mailto:[EMAIL PROTECTED] On Behalf Of Bernard Lis
> Sent: Tuesday, June 21, 2005 17:13
> To: RBG7-L Mailing List
> Subject: [RBG7-L] - Re: cannot connect to database
>
> Try rbsync dbname execute
> ----- Original Message -----
> From: Neil Little
> To: RBG7-L Mailing List
> Sent: Tuesday, June 21, 2005 3:46 PM
> Subject: [RBG7-L] - cannot connect to database
>
> I have a database on a server that has suddenly decided it cannot be
> connected. Autochk says that file number 4 cannot be opened. Anyone know
> how to fix this??
>
> Neil T. Little
> Lehigh Acres Fire Control and Rescue District
> 1000 Joel Boulevard
> Lehigh Acres Florida 33972
> Phone: (239) 344-1608
> Fax: (239) 369-7576
> E-Mail: [EMAIL PROTECTED]
>
>
> --
> No virus found in this outgoing message.
> Checked by AVG Anti-Virus.
> Version: 7.0.323 / Virus Database: 267.7.9/23 - Release Date: 6/20/2005
>
> --
> No virus found in this incoming message.
> Checked by AVG Anti-Virus.
> Version: 7.0.323 / Virus Database: 267.7.9/23 - Release Date: 6/20/2005
>
> --
> No virus found in this outgoing message.
> Checked by AVG Anti-Virus.
> Version: 7.0.323 / Virus Database: 267.7.9/23 - Release Date: 6/20/2005
>
> Dennis Fleming
> IISCO
> http://www.TheBestCMMS.com
> Phone: 570 775-7593
> Mobile: 570 351-5290
> Emmitt Dove
> Manager, DairyPak Business Systems
> Blue Ridge Paper Products, Inc.
> 40 Lindeman Drive
> Trumbull, CT 06611
> (203) 673-2231
> [EMAIL PROTECTED]
> [EMAIL PROTECTED]
>
Albert Berry
Management Consultant
RR2 - 1252 Ponderosa Drive
Sparwood BC, V0B 2G2
Canada
(250) 425-5806
(250) 425-7259
(708) 575-3952 (fax)
[EMAIL PROTECTED]
