On 5/5/2011 1:34 PM, Marc Santhoff wrote:
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 écrit :
Hi Gene,
When I opened my database, no tables, queries or forms were displayed.
Rather than saying "Embedded" at the bottom of the window, it now says
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.jar
(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" mode
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 find
the answer there if no one else answers here.
Alex
From the forum archive I found that I had to create a new database
file, unzip the damaged file, and copy the data files to the new
unzipped file. I then dragged the queries and forms from the last
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
nothing different than I had for several years when this problem happened.
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
If that is the case, I would think that I would not be able to retrieve
the data and script files with no errors from the unzipped file. When I
get the failure, the only thing that happens is that it now thinks that
there is an external JDBC database, rather than the internal one.
I now copy the file and save it under a different name after I make
changes so that I don't have to re-enter data.
Maybe I will do some editing on my wife's computer to see if there is
something wrong with mine.
--
-----------------------------------------------------------------
To unsubscribe send email to [email protected]
For additional commands send email to [email protected]
with Subject: help
