Unoffical empeg BBS

Quick Links: Empeg FAQ | RioCar.Org | Hijack | BigDisk Builder | jEmplode | emphatic
Repairs: Repairs

Topic Options
#269387 - 11/11/2005 17:11 Identify DB files format??
hybrid8
carpal tunnel

Registered: 12/11/2001
Posts: 7738
Loc: Toronto, CANADA
Ok, so I have a program that stores some content in some database files locally. Does anyone know of tell-tale giveaways with regards to what DB such files would be for? ie. mySQL, Borland, Access, etc..

I have no problem going through them with a hex editor to look for details as well as looking for any library files that may indicate which DB format.

Suggestions welcome.

Bruno
_________________________
Bruno
Twisted Melon : Fine Mac OS Software

Top
#269388 - 11/11/2005 17:31 Re: Identify DB files format?? [Re: hybrid8]
tman
carpal tunnel

Registered: 24/12/2001
Posts: 5528
What OS your app runs on would be helpful

Top
#269389 - 11/11/2005 17:49 Re: Identify DB files format?? [Re: hybrid8]
blitz
addict

Registered: 20/11/2001
Posts: 455
Loc: Texas
What's the name of the program you are running?

Top
#269390 - 11/11/2005 21:32 Re: Identify DB files format?? [Re: tman]
hybrid8
carpal tunnel

Registered: 12/11/2001
Posts: 7738
Loc: Toronto, CANADA
It's program running in Windows. Forgot to write that the first time around, sorry.
_________________________
Bruno
Twisted Melon : Fine Mac OS Software

Top
#269391 - 11/11/2005 21:42 Re: Identify DB files format?? [Re: hybrid8]
andy
carpal tunnel

Registered: 10/06/1999
Posts: 5916
Loc: Wivenhoe, Essex, UK
What are the files called and what file extension do they have ?
_________________________
Remind me to change my signature to something more interesting someday

Top
#269392 - 12/11/2005 00:47 Re: Identify DB files format?? [Re: hybrid8]
mlord
carpal tunnel

Registered: 29/08/2000
Posts: 14493
Loc: Canada
What does magic have to say about them? (aka the file command under Linux)

Top
#269393 - 12/11/2005 01:02 Re: Identify DB files format?? [Re: mlord]
wfaulk
carpal tunnel

Registered: 25/12/2000
Posts: 16706
Loc: Raleigh, NC US
I couldn't find any magic number file that specfied any database files. That said, it might be something else altogether that there is a magic number entry for.
_________________________
Bitt Faulk

Top
#269394 - 14/11/2005 04:50 Re: Identify DB files format?? [Re: andy]
hybrid8
carpal tunnel

Registered: 12/11/2001
Posts: 7738
Loc: Toronto, CANADA
Hmm... There were:

.DAT (pretty generic sounding)
.IDX (along with this one)
.BLB (blob for binary data?)
.dod (the biggest files of all, leading me to think all the good stuff was in these)

I'd swear there were at least two others when I checked on Friday, but those appear to be it.

Bruno
_________________________
Bruno
Twisted Melon : Fine Mac OS Software

Top
#269395 - 14/11/2005 06:26 Re: Identify DB files format?? [Re: hybrid8]
Roger
carpal tunnel

Registered: 18/01/2000
Posts: 5683
Loc: London, UK
Quote:
I'd swear there were at least two others when I checked on Friday, but those appear to be it.


Could have been lock files. Did you have the application open at the time?

Those .DAT/.IDX extensions are a bit too generic. Could you upload a hex dump of the first (say) 1Kb of each of those files?
_________________________
-- roger

Top
#269396 - 15/11/2005 01:30 Re: Identify DB files format?? [Re: Roger]
hybrid8
carpal tunnel

Registered: 12/11/2001
Posts: 7738
Loc: Toronto, CANADA
I found out what DB is being used. Funnily enough, they credit the DB company in their About window. Doh!

It's DBISAM which I'd never heard of before. Though I still don't know if they're doing something "different" with the larger files. Seems like the data is being purposefully obfuscated.

Bruno
_________________________
Bruno
Twisted Melon : Fine Mac OS Software

Top
#269397 - 15/11/2005 02:34 Re: Identify DB files format?? [Re: hybrid8]
JBjorgen
carpal tunnel

Registered: 19/01/2002
Posts: 3584
Loc: Columbus, OH
IIRC, I think you can read DBISAM files with MySQL. Worth a shot.
_________________________
~ John

Top
#269398 - 15/11/2005 03:40 Re: Identify DB files format?? [Re: hybrid8]
StigOE
addict

Registered: 27/10/2002
Posts: 568
The program using these database files wouldn't by any chance be DVDProfiler, would it?

Stig

Top
#269399 - 15/11/2005 14:06 Re: Identify DB files format?? [Re: StigOE]
hybrid8
carpal tunnel

Registered: 12/11/2001
Posts: 7738
Loc: Toronto, CANADA
It's actually for a program for ordering car parts that lacks any type of export feature. Posted for a friend who uses it at his shop. The next version is apparently moving to SQLite - which would likely solve the access problems on its own. But my friend has also been requesting some export format which may also come in an update. I think he's happy for now.
_________________________
Bruno
Twisted Melon : Fine Mac OS Software

Top