×
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Contact US

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Dbase IV: scrambldd DBFs and migration problem Novell->W2003 server

Dbase IV: scrambldd DBFs and migration problem Novell->W2003 server

Dbase IV: scrambldd DBFs and migration problem Novell->W2003 server

(OP)
Hello all,

have dBase IV V2.0, Netware 4.11 server and now 15 clients (all win98).
This worked fine for MANY years.

But the company grew, more and more clients had been added. Two or more clients work on the same DBF file now and trouble begun: sometimes a record is missing, or 2 clients are modifying the same record (see examples below).

Win98 is dying.. we tried to update the clients to WinXP. No chance! 50 or more records in DBF files missing just after some typing. Terrible. We stopped the XP test immediately.

We are also about to replace our Netware server by a W2003 server. But similar problems as described above with W98 and Novell!!

Example1: dbase error msg 'eof of file', and after "USE FILE INDEX FILE / GO BOTTOM"  recno() points to EOF. REINDEX will help but the last entered record is lost.

Example2:
Client#1 writes an invoice and prints it (and thus 'locks' it), and seconds later client#2 who wants to write an invoice as well is modifying the already finished invoice of client#1, overwriting the data of the other owner of the record.

We are quite desparate already.
Thanks for any help!
Volkmar
 

RE: Dbase IV: scrambldd DBFs and migration problem Novell->W2003 server

what size is your dbf? Approaching 2GB limit??

RE: Dbase IV: scrambldd DBFs and migration problem Novell->W2003 server

(OP)
The biggest file is just 50MB or so. Most of the DBFs are around 3MB only.

RE: Dbase IV: scrambldd DBFs and migration problem Novell->W2003 server

Here is a program I wrote long ago to locate mad records or bad data - FAQ290-4606: Program to check a table for bad or invalid contents

I worked in a NetWare 5.0 environment years ago and had occasional problems with WinMe computers messing up records.  My guess was that it usually happened when someone was trying to print reports and somehow WinMe or NetWare or both scrambled the file/printing handles, since we would find text being sent to the printer overwriting the table records.  Yes, a huge problem.  We also found that at the time that Novell did not have reliable drivers for Windows XP.

(Frankly, Microsoft did not aggressively fix compatibility issues between NetWare and XP, Novell filed at least one complaint alleging MS took a year and a half just to fix one of the networking issues they reported with MS software.  Therefore, many companies switched to Windows servers to resolve the longstanding problems.)

Eventually we went to Win2000 server and that data corruption problem went away.  XP is much better and more flexible than Win98 or WinMe - on a Microsoft Server, of course.  Server 2003 is a solid and stable product, but of course MS is soon going to push for people to get Server 2008.

RE: Dbase IV: scrambldd DBFs and migration problem Novell->W2003 server

(OP)
Hello,
well, we tried a win2K server already instead of the netware server.. same problem.
We also tried WinXP clients... problem even worse.
Here the problem happens when 2 or more clients are modifying the same DBF file (but different records).

RE: Dbase IV: scrambldd DBFs and migration problem Novell->W2003 server

I spoke of issues I had with dBase 5 for DOS.  Have you tried RLOCK and UNLOCK?  Do you have problems mainly when you're editing records or appending records or both?

Frankly, you need to get out of the DOS world soon. These languages are some 15 years old and more problems will likely crop up as time goes on.  Even though it may cost some to have the programs rewritten, you are already paying a cost from the  data corruption, delays to fix the data, etc.  In the long run you need to update.

RE: Dbase IV: scrambldd DBFs and migration problem Novell->W2003 server

(OP)
We already tried dBase V as well. Same thing.
Yes I have tried RLOCK... it is not a programming error.
Seems to be some delay with the internal record locking system of dBase.
Yes we know that we have to update and are already working on a completely new software, but it takes time.

RE: Dbase IV: scrambldd DBFs and migration problem Novell->W2003 server

Is there a Dbase equivalent for Foxpro function FLUSH which commits buffers to disk

RE: Dbase IV: scrambldd DBFs and migration problem Novell->W2003 server

(OP)
Flush?
No, there is none.
Also, we already switched off all cashing in the netware clients....

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close