Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]
Groups > comp.lang.clipper.visual-objects > #7430 > unrolled thread
| Started by | Martin <spam@spam.spam> |
|---|---|
| First post | 2014-11-18 12:04 +0000 |
| Last post | 2014-11-20 15:33 +0000 |
| Articles | 5 — 3 participants |
Back to article view | Back to comp.lang.clipper.visual-objects
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
| From | Martin <spam@spam.spam> |
|---|---|
| Date | 2014-11-18 12:04 +0000 |
| Subject | Repairing 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]
| From | dlzc <dlzc1@cox.net> |
|---|---|
| Date | 2014-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]
| From | D.J.W. van Kooten <vankooten@removethis.ic2.com> |
|---|---|
| Date | 2014-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]
| From | dlzc <dlzc1@cox.net> |
|---|---|
| Date | 2014-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]
| From | Martin <spam@spam.spam> |
|---|---|
| Date | 2014-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