Results 1 to 3 of 3
  1. #1
    Join Date
    Jun 2013

    Unanswered: Extracting BLOBs from Paradox 7 database

    I have recently migrated a Paradox 7 database to SQL Server 2008. I later realize that some of the tables contained BLOB fields, which I need to extract. I understand that in Paradox, these fields don't actually contain the BLOBs, but rather a reference to an *.mb file wherein the BLOB lies at some position.

    The thing is, I have trouble accessing the BLOBs even from a native Paradox 7 environment (I'm using Windows 7, but Paradox 7 doesn't seem to mind as long as I run it in Win95 compatibility mode). The only apparent content of the column is the string "<BLOB OLE Object>" and Paradox seems to be oblivious of the fact that it should be a reference to an *.mb file. I have tried to look for a suitable .NET library to help me handle the *.mb files, but have had no luck so far.

    What to do? =/

  2. #2
    Join Date
    Jun 2013
    New detail. Paradox reports "Blob has invalid header" in the bottom bar. In Paradox 7 and 11 both. Am I doomed? =O

  3. #3
    Join Date
    Dec 2007
    the db and mb must remain in use together, in synch, just like a db and px.. you can't get anything out of the db for that field otherwise.. since a "blob" can potentially be anything (text, jpg, word doc, acad file, etc.) all you can do is extract it to a file and deal with it elsewhere..

    scan table
    x = [blob]
    writefile x

    if the blob file is no longer in synch with the table, or the file is missing or damaged, yes, you're doomed.. the repair tools can't fix a blob, because the tools don't know what the content is supposed to be
    Steven Green - Myrtle Beach, South Carolina USA

    Oasis Trading Post
    - Collectibles and Memorabilia
    - Vintage Lego Sets and Supplies
    - and Paradox Support, too

Posting Permissions

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