Reverse engineering / what's an .idx file?

[Evenflow]

I need to access database information from an application whose readme file states the database engine used is Pervasive.SQL 7 (upgraded from Btrieve 6.15). We have no assistance from the vendor who created this app. I can't locate any .mkd or .ddf files (i am new to btrieve, but from documentation gathered that was a file extension i may find) ... there is however a 698 MB file with the extension .idx that the app's search engine seems to point to. Using Pervasive's 2000i ODBC driver and trying to populate a table with this data file results in a status code "30 - Btrieve error" and i get no further.

I have a feeling i am barking up the wrong tree. Any suggestions of what files to look for, on that application's workstation? Anyone know what could be contained in that huge .idx file?

Thanks much,
Database Blues in South Dakota

 

[Pervasivite]

Yes, your feeling is probably correct. A status 30 indicates that the file is not Btrieve or MKDE (which are basically the same thing) and so I would guess that it is an index file created by the application's search engine in some other format. Btrieve or MKDE don't require a specific extension and so you'll just have to use a utility like the Function Executor to open files you think might be the right ones and see if you get a status 0 for a successful open.

Regards,
Pervasivite