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
|
|
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]
