is it foxpro? how to tell

[lisa127]

we have a server that ran SCO UNIX and has some information in a database of some sort that we need to get out of there. we don't know what was running on the server - but suspect with some files named *.idx that it might be a Foxpro 2.6 database.

what can we look for to know for sure? If we just browse in the files is there a way to confirm the format as FoxPro?

thanks,
Lisa

 

[JRB-Bldr]

You mention an IDX file which the extension for an old form of Foxpro Index file, but you do not mention any other file extensions which might indeed have some real data in them, such as DBF's.

You also do not mention if you are trying to extract the source code from an EXE, APP, or FXP file.

With that information we can better help you out.

One thing you can do until then is to use a Hex editor to look into the internals of the files - knowing something about the file header information can also help us help you.

Good Luck,


JRB-Bldr
VisionQuest Consulting
Business Analyst & CIO Consulting Services
CIOServices@yahoo.com

 

[lisa127]

all I have right now is a text file that appears to be a printed listing as if someone did "ls -l" on all the file systems - so file names are all I have to work with.
The directory structure seems to have file names in pairs like:
C_0234
C_0234.idx
D_0247
D_0247.idx

nothing came up when I scanned for dbf or fpx

I don't think they want to find the source code - just the data that should be in the database - though if we found source code it could help us identify these cryptically named files.

we had some acquisitions awhile back and this is a server from one of those companies but no one knows anything about it anymore except that it houses data that we need to get off of it into some accessible form. Sorry to be so obtuse.

 

[NasibKalsi]

Plus

login as root

and try
ls -R fox*

Will show if there is foxpro installed.


If meomory serves me, SCO FoxPlus(Pro) was not compile_able to binary executable. I have seen .idx extensions for some other languages. You can also try 'cat ' command to print first few line and 'tail ' command to list last few line. It will give some clues about the data.

After making a copy, try opening in Windows XL. Try renaming the file c_xxxx to c_xxxx.dbf and then try opening again in XL.