HI,
I have a small financial apllication producing BTRIEVE format (thats what the vendor told me ). Vendor is not disclosing any further details.

I have to create reports out of this db, but have no idea how btrieve works or BT format looks like. ( And I really don't want to dig in this deeply...)
SQL would be no problem...

So I took a look on the directories structure.
All I can find, looking somehow related to my data here, is a set of DDF and BTW files.

For reporting it would be OK to have a data dump exported weekly.
So....is there any wizard available which could covert my data to sql, or a I dreaming ?

thanks for any help

US

You don't "convert Btrieve to SQL". Your options will depend on several things:
-- What version of Btrieve/Pervasive does this application use? If it's not PSQL 2000 (or V8 or V9), you are going to have a hard time finding an ODBC driver for it.
-- You're going to need DDFs files that accurately describe the data files. These should come from the vendor since they know the exact record structure.

Now, once you've got an ODBC driver, DDFs, data files, a PSQL engine, and an ODBC application (Excel, Access, Crystal Reports, etc), you would create the ODBC DSN pointing to your DDFs/Data files and then use that DSN in the application.

I have ODBC for MS-SQL, MS-Access, MySQL, Oracle, and Sybase, but need to know where to get one for Betrieve/Pervasive.

Does anyone know?

DBS4M

I would start at http://www.pervasive.com. Depending on your version though, you might have a hard time finding an ODBC driver. I think Data Direct (http://www.datadirect.com) has one too.