No longer able to open a ODB file

users
#1

When I try to open this file: http://db.tt/CN65sXtn
I am presented with the Filter Selection dialog, from which I choose ODF database.
I next get a 'General Error'.
Clicking on 'Tables' gives:
     The connection to the data source "Books' could not be established.
     The driver class " could not be loaded.
Clicking More gives three errors
The connection to the data source "Books' could not be established.
     Error code: 1000 The driver class '' could not be loaded.
     SQL Status: HY000 The driver class '' could not be loaded.

and the file remains inaccessible.

One day the file worked and saved without problem. The next day it does not open on any machine.

A similar database opens without problem.

Is there a way to recover this file?

#2

Scott ,

this is not a odb file , its comming from a older oo version (1.2) could be a swx, sxc, sxd, but as far as i know there was no database for 1.2

#3

Fernand,

Thanks for the answer, although I admit I'm seriously puzzled by that. The file has been in use for a couple years and at least originally was a ODB. Most recently being opened and used without problem in LO 3.4.x on a weekly basis.

Any ideas on how to recover at least the table data from the file?

#4

Scott ,

no, because it is no longer a zip archive, were you normaly can find a archive with the "data" file.

i supose the original odb is "overwritten" by a other file ?

open the file with a text-editor, you wil find some meta-data en scrambled information

hopes you find somewhere a backup :slight_smile:

Greetz

Fernand

#5

Fernand,

I have restored a backup from a month ago. Since December was a relatively slow month, not too much has been lost.

Thanks much, though, for confirming that this file is of no use.

Scott

#6

Scott ,

this is not a odb file , its comming from a older oo version (1.2) could
be a swx, sxc, sxd, but as far as i know there was no database for 1.2

Hi Fernand, Scott,

It is, was, an ODF database file it seems.

The physical file structure, however, is corrupt.

Using zip -FF, two times, gets some parts in readable shape:
a couple of forms, well enough to tell the name of the woman that
created them, date last edited, etc. That it was created with LibO 3.3
on 32bit windows. I can pull the control types, the field names they are
attached to, etc. - so one could salvage forms fairly easily, IMO,
didn't actually try moving them to a non-corrupt, new, file.

The _data_ however - some, or all, may be there, at least there is a
241K block of bytes left after the two forms and manifest.xml and a
couple other files are accounted for. However trying to recover any of
that would be a rather more laborious endeavor and quite frankly
costly...so unless this is some rather valuable stuff..I'd call it a
bin_bucket case.

For what it's worth if you are still using LibO 3.3 I would really
recommend upgrading to 3.4.5 today!

Best wishes,

//drew

#7

I just downloaded this file. Then I changed the extention
from .odb to .zip and tried to unzip it. I got the following Error
message:
Archive: /home/dan/Downloads-64/Books.zip
[/home/dan/Downloads-64/Books.zip]
          End-of-central-directory signature not found. Either this
file is not a zipfile, or it constitutes one disk of a multi-part
archive. In the latter case the central directory and zipfile comment
will be found on the last disk(s) of this archive.
zipinfo: cannot find zipfile directory in one
of /home/dan/Downloads-64/Books.zip
or /home/dan/Downloads-64/Books.zip.zip, and cannot
find /home/dan/Downloads-64/Books.zip.ZIP, period.
     Recovery of the file is unlikely. I also opened the file using
Gedit (text editor). It was showing a combination of UTF-8 characters
and invalid characters. Here is a section that is all UTF-8 characters:

<office:document-meta
xmlns:office="urn:oasis:names:tc:opendocument:xmlns:office:1.0"
xmlns:xlink="http://www.w3.org/1999/xlink"
xmlns:dc="http://purl.org/dc/elements/1.1/"
xmlns:meta="urn:oasis:names:tc:opendocument:xmlns:meta:1.0"
xmlns:ooo="http://openoffice.org/2004/office"
xmlns:grddl="http://www.w3.org/2003/g/data-view#" office:version="1.2"
grddl:transformation="http://docs.oasis-open.org/office/1.2/xslt/odf2rdf.xsl">
<office:meta><dc:date>2011-01-15T14:02:55.95</dc:date><dc:creator>Carolyn
Friedemann</dc:creator><meta:editing-duration>PT2M32S</meta:editing-duration>
<meta:editing-cycles>4</meta:editing-cycles><meta:generator>LibreOffice/3.3$Win32
LibreOffice_project/330m19
$Build-5</meta:generator><meta:document-statistic
meta:table-count="0" meta:image-count="0" meta:object-count="0"
meta:page-count="1" meta:paragraph-count="0" meta:word-count="0"
meta:character-count="0"/></office:meta></office:document-meta>PK

     Maybe someone can make some sense of this.
     I'm no sure what the
                  office : version ="1.2" means.
There was no such version. OOo went from 1.0 to 1.1.5 and then to 2.0.

-- Dan

#8

Maybe I am missing the point, but I've just downloaded your file and opened
it with BASE.

It has 304 records in the archived books table and 503 in the books table.
Maybe worth the time for you to try again.

#9

Oldlace,

What version of LO are you using?

#10

Maybe I am missing the point <snip>

or not - just downloaded it a second time - it's opening without a
problem now..small difference the first downloaded file is 252K the new
one is 1.5Meg..

//drew

#11

That is a new copy of the file.

#12

<snip>

     Maybe someone can make some sense of this.
     I'm no sure what the
                  office : version ="1.2" means.
There was no such version. OOo went from 1.0 to 1.1.5 and then to 2.0.

Hi Dan,

It's referring to the ODF version in this case, though would need to
look at the entire line to be certain.

//drew

#13

Hi Scott,

Scott D Friedemann schrieb:

When I try to open this file: http://db.tt/CN65sXtn

I would like to look at it, but cannot get it. Perhaps send it to me directly?

Kind regards
Regina

#14

Regina,

I've put the file back on the Web and will leave it there for a while.

http://db.tt/CN65sXtn

#15

Hi Scott,

Scott D Friedemann schrieb:

Regina,

I've put the file back on the Web and will leave it there for a while.

http://db.tt/CN65sXtn

I got a file with 250KB. I have opened it with "IZarc", which tried to "repair" it. I have tried to repair it with "Zip Repair" and with "DiskInternals Zip Repair Tool". In all cases I see the forms but the data folder is empty. Normally the data folder holds the database itself and the queries. I cannot determine, whether the data folder is really empty, but you cannot recover it with this tools. :frowning:

Kind regards
Regina

#16

The database/data beginning is there, but it is incomplete. I did not examine the header closely to see how much data was lost in the truncation of the file.