Re: [libreoffice-users] No longer able to open a ODB file

On Thu, 2012-01-26 at 17:30 +0100, Fernand Vanrie wrote:
> 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
> > 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?

           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




-- 
For unsubscribe instructions e-mail to: users+help@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted