Re: Base Embedded Link Lost

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 =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 di=
g
>>> 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
>> 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 happe=
ned.
>
> 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=20
the data and script files with no errors from the unzipped file.  When I=20
get the failure, the only thing that happens is that it now thinks that=20
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=20
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=20
something wrong with mine.

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