Re: Base Embedded Link Lost

Gene Kohlenberg <[email protected]> Wed, 04 May 2011 19:01:10 -0400
Newsgroups gmane.comp.openoffice.dba.user
Message-ID <[email protected]>
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 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" mod=
e
> 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=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.

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 happened=
.

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