Re: Base Embedded Link Lost

Marc Santhoff <[email protected]> Thu, 05 May 2011 19:34:04 +0200
Newsgroups gmane.comp.openoffice.dba.user
Message-ID <[email protected]>
Am Mittwoch, den 04.05.2011, 19:01 -0400 schrieb Gene Kohlenberg:
> On 5/4/2011 4:41 AM, Alexander Thurgood wrote:
> > Le 03/05/11 21:10, Gene Kohlenberg a =E9crit :
> >
> > Hi Gene,
> >> When I opened my database, no tables, queries or forms were displaye=
d.
> >> Rather than saying "Embedded" at the bottom of the window, it now sa=
ys
> >> JDBC, and my data cannot be accessed.  I can't find any place to
> >> reestablish the link with the embedded database.
> >>
> >> I am using Windows XP Media Center Edition, SP3 on a Dell Inspiron
> >> E1505 computer with OpenOffice.org 3.3.0, OOO330m20 (Build:9567).
> >>
> >> How can I re-establish a link to my database?
> >>
> > This sounds like you are using either a different version of hsqldb.j=
ar
> > (1.8.10, 1.9, 2.0 ?) on your system (i.e. you have multiple copies of
> > hsqldb.jar), or you have previously used the hsqldb.jar in "server" m=
ode
> > and not "file" mode.
> >
> >  From what I can remember, you'll have to unzip your ODB file and dig
> > into the various text editable files to see where things have gone
> > wrong. Try searching on the openoffice.org forum, you'll probably fin=
d
> > the answer there if no one else answers here.
> >
> >
> > Alex
> >
>  From the forum archive I found that I had to create a new database=20
> file, unzip the damaged file, and copy the data files to the new=20
> unzipped file.  I then dragged the queries and forms from the last=20
> backup into the new file, and renamed it as an odb file.

That must have been a very old forum posting. Th last time I have heard
or read about such kind of problem dates back to OO.o Version 2.x.

> It seems that the embedded system is not all that robust.  I had done=20
> nothing different than I had for several years when this problem happen=
ed.

Since you're relatively alone with this type of failure:
Have you ruled out other sources of failure? Slowly dying hardware like
power supply or disk drive can easily destroy random files.

HTH anyhow,
Marc

--=20
Hier l=E4uft Ehnix, voll kompatibel zu Garnix

--=20
-----------------------------------------------------------------
To unsubscribe send email to [email protected]
For additional commands send email to [email protected]
with Subject: help