Results 1 to 4 of 4
  1. #1
    Join Date
    Jul 2006
    Posts
    1

    Unanswered: BTRIEVE to sql ?

    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

  2. #2
    Join Date
    Dec 2001
    Posts
    1,109
    Provided Answers: 4
    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.
    Mirtheil Software
    Certified Pervasive Developer
    Certified Pervasive Technician
    Custom Btrieve/VB development
    http://www.mirtheil.com
    I do not answer questions by email. Please post on the forum.

  3. #3
    Join Date
    Feb 2004
    Location
    Irving, TX (Dallas, Fort Worth)
    Posts
    379

    Where

    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

  4. #4
    Join Date
    Dec 2001
    Posts
    1,109
    Provided Answers: 4
    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.
    Mirtheil Software
    Certified Pervasive Developer
    Certified Pervasive Technician
    Custom Btrieve/VB development
    http://www.mirtheil.com
    I do not answer questions by email. Please post on the forum.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •