Trying to import data from Btrieve into SQL Server
Posted on 2011-02-15
I am have been give 156 btr and 4 ddf files. I have been asked to extract the data and export this into either MS Access or SQL Server. Unfortunately, I have no experience of Btrieve and have no access to the Btrieve server / Application used to extract these files. I do have the following information: btrieve version 6.15.445 on Netware.
I have so far, downloaded a trial version of the Pervasive software version 10.30.017.000 and converted the btr files to 9.5. I have also used the Scalable DDF utility to upgrade the DFF files from version 3 to version 4 as requested by the Pervasive application. I have then created a new database and pointed it to where the files are stored. Unfortunately, no tables are shown in the database.the DDF files show up though. I have tried updating the file.ddf file but keep getting the following error message: [LNA][Pervasive][ODBC Engine Interface][Data Record Manager]The owner name is invalid(Btrieve Error 51)
Any suggestions please?