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