Page 3 of 4

Re: [Solved] Database unable to open

Posted: Tue Jan 16, 2018 4:19 pm
by Sliderule
BarneyinOZ

I just sent you a PM ( Private Message ).

Sliderule

Re: [Solved] Database unable to open

Posted: Thu Jan 18, 2018 5:07 pm
by Hendrie
Hi -just discovered this forum. I hope you can help.

I have occasion to use an OpenOffice database just a few times a year. Unfortunately when I used it today there was a problem.

The OpenOffice database refused to save and when I restarted the computer the database could not be loaded. Error message said something about a connection not being able to be made.

I discovered that I had SysInfo Tool v1.0 on my computer (bought some time ago) so used it (apparently successfully) to repair the database.

Now when I try to load the repaired database it tells me that I should be User: SA

Any suggestions most welcome.

Hendrie

Re: [Solved] Database unable to open

Posted: Thu Jan 18, 2018 5:13 pm
by Hendrie
With regard to previous post the errors are reported as :

SQL Status: S1000 Error code: -37 User not found: SA

Re: [Solved] Database unable to open

Posted: Thu Jan 18, 2018 10:46 pm
by Hendrie
Fingers crossed I now seem to have recovered the data from the last backup file that wasn't O kb in length.

Re: [Solved] Database unable to open

Posted: Mon Feb 19, 2018 4:53 pm
by vayaplaya
I cannot open my database, even though it has been opened and closed several times this past week. Today it asks for Filter Options when opening the file. If the Base file is opened using OpenOffice Writer, it consists of 7,600 pages with only readable English in the last 7 pages (beginning with mimetypePK and database/logPK). The .obd.lck file was not deleted when I closed the database the last time and then quit Apache OpenOffice. On all occasions previously when power has been disrupted, Apache OpenOffice was able to recover the file on start-up.

The last update for macOS (High Sierra 10.13.3) was on Feb 8, 2018; OpenOffice has been very unstable (unexpected shut downs) since then. Sometimes the base file has been open (and was recovered) and sometimes it was not open.

Any help to recover this database will be much appreciated.

Re: [Solved] Database unable to open

Posted: Mon Feb 19, 2018 6:35 pm
by nhsome3
I am having an issue with opening an odb file. It sends me to select a filter. Not sure how to fix.


Thanks

OpenOffice 4.1.2 on Windows 10 pro

Re: [Solved] Database unable to open

Posted: Mon Feb 19, 2018 6:47 pm
by Sliderule
vayaplaya and/or nhsome3:

Since you cannot open your Base file ( *.odb ) . . . if you post your file here, or, some other file sharing link ( such as MediaFire https://www.mediafire.com/ ) so I can determine if I might be able to open the file ( at least the database portion ) . . . I will try to help.

Sliderule

Re: [Solved] Database unable to open

Posted: Mon Feb 19, 2018 7:23 pm
by nhsome3

Re: [Solved] Database unable to open

Posted: Mon Feb 19, 2018 7:35 pm
by Sliderule
nhsome3 wrote:Here is a link to the file.
http://www.mediafire.com/file/gw5nm34zi3piw0z/cars.odb
Thanks
The above file link you gave, is extremely small in size ( 1536 bytes ) and, according to MediaFire, was uploaded 2013-11-19 09:40:32. Nothing internal to the file can be recovered . . . that is . . . changing to a zip file and repairing.

Sliderule

Re: [Solved] Database unable to open

Posted: Mon Feb 19, 2018 7:42 pm
by nhsome3
Thanks,
Did not have much data. But it will take me a while to recreate all table designs. I have no idea on why it list that date. I just set up an account and uploaded it.

Re: [Solved] Database unable to open

Posted: Mon Feb 19, 2018 10:24 pm
by vayaplaya
This is the link from mediafire: http://www.mediafire.com/file/i58ndk84f ... Cloud2.odb. I hope you can do something with it.

Re: [Solved] Database unable to open

Posted: Mon Feb 19, 2018 11:00 pm
by Sliderule
vayaplaya wrote:This is the link from mediafire: http://www.mediafire.com/file/i58ndk84f ... Cloud2.odb. I hope you can do something with it.
I was able to 'restore' the database contents, that is, the HSQL 1.8.0.10 ( Embedded Database ), BUT, I was not able to recover any Queries, Forms, or, Reports.

In your database, the table "EventDescriptionTable1" contains 8104 records.

What should I now do with it, so, you can get it, assuming you want it?

Sliderule

Re: [Solved] Database unable to open

Posted: Mon Feb 19, 2018 11:25 pm
by vayaplaya
I do want it. The queries, forms and reports were seldom used and I can rebuild those. The data, especaily in EventDescriptionTable1 is most important to me. Thank you for your work.

Re: [Solved] Database unable to open

Posted: Mon Feb 19, 2018 11:27 pm
by Sliderule
So, ¿ do you want me to email it to you, or, post it on MediaFire ?

Re: [Solved] Database unable to open

Posted: Mon Feb 19, 2018 11:29 pm
by vayaplaya
If you would email it to me, that would be fine.

You must have magic fingers to to fix these database problems. Thanks.

Re: [Solved] Database unable to open

Posted: Mon Feb 19, 2018 11:34 pm
by Sliderule
vayaplaya wrote:If you would email it to me, that would be fine.

You must have magic fingers to to fix these database problems. Thanks.
Please PM ( Private Message ) me with your email address. I will send it ( the database file ) to you as an attachment. The file size ( bytes ) is now much smaller than before.

Sliderule

Re: [Solved] Database unable to open

Posted: Tue Feb 20, 2018 12:10 am
by vayaplaya
Sliderule brought my database back to life!

Re: [Solved] Database unable to open

Posted: Tue Feb 20, 2018 9:36 pm
by Villeroy
It deserves to live in a safe space now. [Python] Macro to extract and reconnect embedded HSQLDB

Re: [Solved] Database unable to open

Posted: Fri Feb 23, 2018 9:34 pm
by dunnock09
I need to open my database YES the dreaded "provide a filter selection". Any help greatly appreciated.

Re: [Solved] Database unable to open

Posted: Sat Feb 24, 2018 12:43 am
by Sliderule
dunnock09 wrote:I need to open my database YES the dreaded "provide a filter selection". Any help greatly appreciated.
Since you cannot open your Base file ( *.odb ) . . . if you post your file here, or, some other file sharing link ( such as MediaFire https://www.mediafire.com/ ) so I can determine if I might be able to open the file ( at least the database portion ) . . . I will try to help.

Sliderule

Re: [Solved] Database unable to open

Posted: Sat Feb 24, 2018 2:07 am
by dunnock09
Thanks for your speedy reply, I have now successfully found and opened an earlier version and everything I need is intact. Many thanks

Re: [Solved] Database unable to open

Posted: Wed Feb 28, 2018 1:35 pm
by azya123
Hello. I have the same problem with database. I hope to get help from Sliderule. Link to corrupted db here http://www.mediafire.com/file/n6pzd91pf ... ise_db.rar
I tried to use python script from message above but corrupted database opens in librewriter, and this script doesn`t work from writer.
Thanks.(problem was solved by Villeroy in the message below)

Re: [Solved] Database unable to open

Posted: Wed Feb 28, 2018 3:40 pm
by Villeroy
Linux?

Code: Select all

zip -F expertise_db.odb --out expertise._db.out.odb
restores the zip archive.
if not, try harder:

Code: Select all

zip -FF expertise_db.odb --out expertise._db.out.odb
(your expertise_db requires only one -F)

Now you can reconnect the document to its embedded database (which is not the case yet) or you can extract the database from the document in order to get a more stable database solution. [Python] Macro to extract and reconnect embedded HSQLDB

Re: [Solved] Database unable to open

Posted: Wed Feb 28, 2018 4:26 pm
by azya123
Villeroy, thank you. Problem is solved.

Re: [Solved] Database unable to open

Posted: Wed Mar 21, 2018 7:08 pm
by KbProblem
Hi,

i have kind of the same problem with my database... i've been using it for years and now as i wanted to open it and look something up it was broken. I can open the whole file but as soon as i want to open the table with all the data it shows me an error.
SQL-Status: S1000
Fehler-Code: -29

Can anybody help me with this problem?

Re: [Solved] Database unable to open

Posted: Thu Mar 22, 2018 5:27 am
by Sliderule
KbProblem wrote:Hi,

i have kind of the same problem with my database... i've been using it for years and now as i wanted to open it and look something up it was broken. I can open the whole file but as soon as i want to open the table with all the data it shows me an error.
SQL-Status: S1000
Fehler-Code: -29

Can anybody help me with this problem?
Since you cannot open your Base file ( *.odb ) . . . if you post your file here, or, some other file sharing link ( such as MediaFire https://www.mediafire.com/ ) so I can determine if I might be able to open the file ( at least the database portion ) . . . I will try to help.

Sliderule

Re: [Solved] Database unable to open

Posted: Thu Mar 22, 2018 9:54 pm
by KbProblem
Oh, that would be great :)
http://www.mediafire.com/file/abzaubh4s ... nbank1.odb
Thank you very much!

Re: [Solved] Database unable to open

Posted: Thu Mar 22, 2018 10:13 pm
by Sliderule
KbProblem:

The Base file database contents referenced above could not be recovered.

In your Base file, the database sub-directory, a data file did not exist, and, the backup file was corrupt.

Sliderule

Re: [Solved] Database unable to open

Posted: Thu Mar 22, 2018 11:44 pm
by KbProblem
Hmmm.... do you know why this did happen? Just curiousity.

Re: [Solved] Database unable to open

Posted: Thu Mar 22, 2018 11:50 pm
by Sliderule
KbProblem wrote:Hmmm.... do you know why this did happen? Just curiousity.
In all probability you shut down your computer and the OpenOffice / LibreOffice program before it completed writing the file to the storage location. It has never happened to me, very long time I have used OpenOffice on any application.

Since I was not present when it happened to your file, I cannot say with any degree of certainty.