Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]


Groups > comp.lang.clipper.visual-objects > #7430 > unrolled thread

Repairing DBF options

Started byMartin <spam@spam.spam>
First post2014-11-18 12:04 +0000
Last post2014-11-20 15:33 +0000
Articles 5 — 3 participants

Back to article view | Back to comp.lang.clipper.visual-objects


Contents

  Repairing DBF options Martin <spam@spam.spam> - 2014-11-18 12:04 +0000
    Re: Repairing DBF options dlzc <dlzc1@cox.net> - 2014-11-18 06:59 -0800
    Re: Repairing DBF options D.J.W. van Kooten <vankooten@removethis.ic2.com> - 2014-11-19 00:25 +0100
      Re: Repairing DBF options dlzc <dlzc1@cox.net> - 2014-11-19 07:23 -0800
        Re: Repairing DBF options Martin <spam@spam.spam> - 2014-11-20 15:33 +0000

#7430 — Repairing DBF options

FromMartin <spam@spam.spam>
Date2014-11-18 12:04 +0000
SubjectRepairing DBF options
Message-ID<m4fcit$ono$1@dont-email.me>
Hello

Sometimes we get DBFs going completely haywire, corruption ect DESPITE 
ADS, I am currently able to repair by doing a copy using a custom DBU 
with DBFCDX and ADS drivers linked in. I basically skip past all the 
errors and get a DBF I can then use.

The problem is vista and above do not support MSDOS programs, so we need 
an XP computer to run on.

So what windows based alternatives are there for DBF corruption?

Thanks

Martin

[toc] | [next] | [standalone]


#7435

Fromdlzc <dlzc1@cox.net>
Date2014-11-18 06:59 -0800
Message-ID<b271e85d-2862-4ba9-804d-7267bd0f52d5@googlegroups.com>
In reply to#7430
Dear Martin:

On Tuesday, November 18, 2014 5:03:54 AM UTC-7, Martin wrote:
...
> Sometimes we get DBFs going completely haywire,
> corruption ect DESPITE ADS,

Problem number 1.  The server has total control over the DBF header.  So whatever process is overwriting the memory copy of the header, needs to be found and killed.

> I am currently able to repair by doing a copy
> using a custom DBU with DBFCDX and ADS drivers
> linked in. I basically skip past all the 
> errors and get a DBF I can then use.
> 
> The problem is vista and above do not support
> MSDOS programs, so we need an XP computer to
> run on.

You can still get Virtual PC (I think), and run it on Windows 7... even 64 bit.  This gives you 32-bit Windows XP inside a virtual machine.

> So what windows based alternatives are there
> for DBF corruption?

Have a blank copy of the dbf.  Append the necessary number of blank records.  Close the file.  Use fopen and such to copy the header only from this sterile database, onto the corrupted database.  This does not mean the contents, up to the first several records, were not damaged...

If there are no memo fields (or long ints, or...), you can copy the file contents above the header, and append to a blank database as SDF

Back the file up periodically.

Have the ADS server work in a working copy of the actual database, and update the master copy in off time.  (You have a 50% chance of not losing all data this way).

Plenty of 3rd party dbf repair tools.

David A. Smith

[toc] | [prev] | [next] | [standalone]


#7441

FromD.J.W. van Kooten <vankooten@removethis.ic2.com>
Date2014-11-19 00:25 +0100
Message-ID<80ln6a19sd6kaaqbcn3hrp06fsmrao5k0i@4ax.com>
In reply to#7430
On Tue, 18 Nov 2014 12:04:01 +0000, Martin <spam@spam.spam> wrote:

Hello Martin,
>
>Sometimes we get DBFs going completely haywire, corruption ect DESPITE 
>ADS

I think this is caused by allowing DBF data to be read by both ADS and
non ADS processes. I think that we ddidn't have dbf corruption anymore
since we have Non Exclusive Proprietary locking on and start the
program with AX_AXSLocking(true).

This way non ADS programs can not open the DBF (Access denied) but it
can be read r/o (e.g. by Wildseek, ReportPro).


Dick

[toc] | [prev] | [next] | [standalone]


#7451

Fromdlzc <dlzc1@cox.net>
Date2014-11-19 07:23 -0800
Message-ID<ff3b4353-8b31-4400-b4bc-cba01b7c4a1b@googlegroups.com>
In reply to#7441
Dear Martin,

On Tuesday, November 18, 2014 4:25:48 PM UTC-7, D. J. W. van Kooten wrote:
> On Tue, 18 Nov 2014 12:04:01 +0000, Martin <spam@spam.spam> wrote:
> 
> Hello Martin,
> >
> >Sometimes we get DBFs going completely haywire,
> >corruption ect DESPITE ADS
> 
> I think this is caused by allowing DBF data to be
> read by both ADS and non ADS processes.

That being the case, you may have one or more users that are still running non-ADS versions of your app, or 3rd party programs that don't speak ADS.  If you rename the database file in your maintained app, you can at least kill older versions of your app from creating this problem.

Then you'd only have to worry about applications that allow you to select the dbf file to destroy from a menu listing...

David A. Smith

[toc] | [prev] | [next] | [standalone]


#7458

FromMartin <spam@spam.spam>
Date2014-11-20 15:33 +0000
Message-ID<m4l1k9$btp$1@dont-email.me>
In reply to#7451
Only ADS is in use, but sometimes servers crash or get turned off.

Or only ADS local is in use.

And on one site a file grew to gigabytes despite little data in it.

On 19/11/2014 15:23, dlzc wrote:
> Dear Martin,
>
> On Tuesday, November 18, 2014 4:25:48 PM UTC-7, D. J. W. van Kooten wrote:
>> On Tue, 18 Nov 2014 12:04:01 +0000, Martin <spam@spam.spam> wrote:
>>
>> Hello Martin,
>>>
>>> Sometimes we get DBFs going completely haywire,
>>> corruption ect DESPITE ADS
>>
>> I think this is caused by allowing DBF data to be
>> read by both ADS and non ADS processes.
>
> That being the case, you may have one or more users that are still running non-ADS versions of your app, or 3rd party programs that don't speak ADS.  If you rename the database file in your maintained app, you can at least kill older versions of your app from creating this problem.
>
> Then you'd only have to worry about applications that allow you to select the dbf file to destroy from a menu listing...
>
> David A. Smith
>

[toc] | [prev] | [standalone]


Back to top | Article view | comp.lang.clipper.visual-objects


csiph-web