Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1781
  • Last Modified:

FoxBase file structure

Hi all,

I am asking this question on several VFP forums but the answer seems to be very difficult...

VFP lists FoxBase DBF file with 0xFB signature in the help (http://msdn.microsoft.com/en-us/library/aa975386(VS.71).aspx). I suppose this is the old FoxBase (16 bit version 1 or Mac version probably) and I would like to find such DBF file sample or its structure description at least.

Does anybody of you have the old FoxBase or some DBF created in this version available?

Even the older dBase II file format is described at several places (and VFP 9 allows to open it but the header info is not properly decoded), FoxBase DBF is simply nowhere...

I am not interested in FoxBase+ DBF structure - this is known and compatible to dBase III.

TIA

0
pcelba
Asked:
pcelba
  • 8
  • 3
  • 2
  • +4
6 Solutions
 
Olaf DoschkeSoftware DeveloperCommented:
I also have no such dbf at hand. What I found are several dbf recovery tools which also offer to recover a foxbase file. Maybe some of them can convert from one to another dbf format, too. Then you could at least investiaget with some small generated foxbase dbfs. Or why not ask some programmer of such a tool?

Bye, Olaf.
0
 
Kalpesh ChhatralaSoftware ConsultantCommented:
Hi Pavel

DBASE II helpful to you ?
0
 
pcelbaAuthor Commented:
Thanks for answers.

I do have dBase II file.

Conversion tools are good idea but I've tried a few of them without success. Their quality is very problematic - they don't recognize obvious DBF files sometimes and the conversion DBF to DBF ignores platform specific features... Authors comunicate sometimes but nobody knows DBF file with 0xFB signature.

0
 [eBook] Windows Nano Server

Download this FREE eBook and learn all you need to get started with Windows Nano Server, including deployment options, remote management
and troubleshooting tips and tricks

 
Kalpesh ChhatralaSoftware ConsultantCommented:
Not DBASE II DBF File.

I have "DBASE II " Software but it's not running on my XP Machine.

0
 
pcelbaAuthor Commented:
I have even the DBASE II+ source code somewhere... :-)

It is in enhanced dBase II for Z80 CPU.
0
 
lamjed ben amnaCommented:
if you ms office 97 ,you can use ODBC to connect to this file.
0
 
pcelbaAuthor Commented:
What ODBC version are you talking about? If I remember it well the ODBC driver accompanied with Office can read dBase III+ and dBase IV files only. (Newer drivers support dBase V, as well.)

Old FoxBase files having the 0xFB signature are simply nowhere supported and nowhere available (thus we probably don't need to support them :-).

But it would be great if you would have such DBF file available or if you colud tell where did you see this information.

TIA
0
 
Guy Hengel [angelIII / a3]Billing EngineerCommented:
I've requested that this question be deleted for the following reason:

This question has been classified as abandoned and is closed as part of the Cleanup Program. See the recommendation for more details.
0
 
pcelbaAuthor Commented:
AngelIII, since when are you moderating FoxPro forum? Why this relatively young question should be deleted? I am still hoping somebody who knows the structure will contact me. And believe or not I am at EE FoxPro forum almost every day...

OTOH, there are 5 years old unanswered questions at FoxPro forum and nobody is attempting to delete them. Why you don't like this particular question?

0
 
aikimarkCommented:
0
 
aikimarkCommented:
@pcelba

Do you have any of the Borland/Inprise/CodeGear/Embarcadero development tools?  It is possible that they included FoxBase compatibility after acquiring Aston-Tate.
0
 
pcelbaAuthor Commented:
@aikimark

Thanks for your posts! Unfortunately, they did not help... dbf2002 web just lists 0xFB signature as one of possible values with no impact to specific features and exceptions from the common structure published on their web. I cannot determine the structure of FoxBase file from this short description.

I don't have any Borland tool available but I am also not convinced this tools could help. Aston-Tate was developing dBase II, III, and IV but their intention was not to be compatible to FoxBase - product of Fox Software. The compatibility was achieved in opposite direction which also caused some law suits... The possibility Borland tools could read FoxBase file is really very low.

It seems the only possibility to obtain the FoxBase file structure is to buy some old FoxBase for Mac and try to install it in some Mac emulation software.
0
 
aikimarkCommented:
Are you trying to get to the data, convert the data (once), or create an application that uses that (unconverted) FoxBase data?
0
 
pcelbaAuthor Commented:
I am trying to document the lost history... And yes, it could help to create some application that can read FoxBase data.

A usability of such application is questionable if such file does not exist probably. :-)
0
 
Rick HobbsRETIREDCommented:
I have FoxBase, FoxPro, Clipper, etc.  I am a packrat.  I have old memory, mobos, PCs.  Damn, I gotta clean this stuff up.  Woul a copy of FoxBase help you?
0
 
pcelbaAuthor Commented:
If it is FoxBase for Mac then it would be very helpful. Thanks!  I have FoxBase/DOS and FoxPro already. They were my tools in the past.
0
 
Rick HobbsRETIREDCommented:
I didn't packrat any MAC stuff.  Sorry
0
 
pcelbaAuthor Commented:
The answer does not exist probably but I would like to keep the question at EE as the sign of the lost history...

Points were split among all contributing experts.
0

Featured Post

Prep for the ITIL® Foundation Certification Exam

December’s Course of the Month is now available! Enroll to learn ITIL® Foundation best practices for delivering IT services effectively and efficiently.

  • 8
  • 3
  • 2
  • +4
Tackle projects and never again get stuck behind a technical roadblock.
Join Now