The 'typical' btrieve data file starts with the two bytes 'FC'. If so you are half way in luck. The current Pervasive.SQL database engine can read files all the way back to 1.0. However to access them through SQL is a different matter. The SQL engine would need the SQL schema for the file. That is stored in a separate set of '.ddf' files. If you have a valid set of them you truly are set and all you will need to do is create a database that points to the ddfs. If not, the database file itself does not have any field or data type information stored in it except for any parts of the record that may be indexed. The rest are just untyped bytes. If you are lucky using the tools everything will be stored as strings (not likely) and it will be easy to tell what field is what. While you can use the tools that comes with the V8.x product to create the DDF files if need be it is a little clunky. There is a new tool available from menu on the left -> Downloads -> DDF builder. Or It only works with Pervasive.SQL V9. I feel confident that one or more of the other regulars will chime in with their suggestions also. Leonard On 23 Mar 2005 07:13:58 -0800, [email protected] wrote: >Hi, > >I have a large number of binary.NDB database files that I need to >access the contents of. Would anyone know of any utility (or >Access/Excel plugin) that can view the contents of these files or >failing details of the format? > >As far as I can tell they may be created from software from Pervasive, >but I'm not 100% sure and I can't find any reference to them on there >website but I know the original software used a Pervasive MicroKernal >Development Engine. > >Many thanks in advance. > >Cheers > >Sean. Sounds like unicode to me. As Gil mentioned the Btrieve API just does not care what data you put in a file except to sort keys. It does support unicode key sorts. I am not 100% certain the SQL engine supports unicode strings thgough. I am sure the data can be exported, probably fine by BtSearch, but I am not sure about accessing it through a ODBC connection. Leonard On 29 Mar 2005 03:55:12 -0800, 'SeanC' wrote: >Gil, > >I have now bought BtSearch32 but what I have found looking at the files >is that the text within them is stored as two bytes, with the second >byte always null (0x00). Have you seen this format before? Is there >anyway of getting BtSearch32 to strip out these null bytes? > >I need to be able to extract the data with the minimal amount of >effort. If I had a better idea of the file format I would write a >program to do it myself. Is this file structure detailed anywhere? > >Thanks > >Sean. Hello NG, i'm currently searching for a method to convert Betrieve (*.Btr-Files) to a common Database format. (comma separated file would be ok) I tried some tools like btsearch32 and btview, but they won't work. Even if i put the wbtrcall.dll to C: windows system and add the required section to the win.ini btsearch is claiming.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. Archives
March 2019
Categories |