[Solved] Lost database table and queries

Discuss the database features

[Solved] Lost database table and queries

Postby ESgt » Mon Mar 04, 2019 7:16 pm

After working at a new club membership database for a week or so. Now when trying to open the table I get a dialogue box saying: The connection to the data source "<database name>" could not be established. The driver class '' could not be opened.
Could someone please show me how to recover this?

Using Agent Ransack to find all of my *.odb files I found a large number of backup files, apparently produced every few seconds.
They were in a directory ...\AppData\Roaming\OpenOffice\4\user\backup and with numbered filenames like fname.odb_978.odb
I took the highest numbered one and renamed that file to just fname.obd and hey-presto recovered my data table and queries.
Last edited by ESgt on Wed Mar 27, 2019 4:31 pm, edited 1 time in total.
ESgt
OpenOffice version 4.1.6
Microsoft Windows 7 Professional, 64bit
User avatar
ESgt
 
Posts: 6
Joined: Sun Apr 17, 2016 6:12 pm
Location: UK Derbyshire

Re: Lost database table and queries

Postby eremmel » Tue Mar 05, 2019 1:24 pm

It might be that Java has been updated recently on your system. Go to Extra -> Options -> OpenOffice -> Java and select a Java version. Note that you have to use a 32-bit Java version.
Is your question answered: edit your initial post add "[Solved]" to the subject and check V
LO4.2.8 for work with ORB; AOO4.1.4,LO5.2.5/6.0.5 on W7E SP1 64bit
It's Microsoft marketing that tells you computers are qualified for non-technicians
User avatar
eremmel
Volunteer
 
Posts: 1036
Joined: Tue Dec 30, 2008 1:15 am
Location: Barneveld, Netherlands

Re: Lost database table and queries

Postby Villeroy » Tue Mar 05, 2019 1:49 pm

When you select a version in the options dialog, you see the path of the selected version below the list. If the path starts with "C:\Program Files (x86)\" the Java version is compatible. Any path with "C:\Program Files\" indicates a 64-bit Java which is incompatible with OpenOffice unless your whole Windows system runs on 32 bit.
See Troubleshooting Open/LibreOffice and Java
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04, no OpenOffice, LibreOffice 6.x
User avatar
Villeroy
Volunteer
 
Posts: 26765
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

Re: Lost database table and queries

Postby Villeroy » Tue Mar 05, 2019 1:56 pm

Quick test on the file:
Change the file name extension to .zip instead of .odb. OpenOffice documents are zip archives actually.
If you can open the renamed archive with a zip tool it is rather unlikely that the file is damaged.
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04, no OpenOffice, LibreOffice 6.x
User avatar
Villeroy
Volunteer
 
Posts: 26765
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

Re: Lost database table and queries

Postby ESgt » Wed Mar 06, 2019 7:15 pm

eremmel wrote:It might be that Java has been updated recently on your system. Go to Extra -> Options -> OpenOffice -> Java and select a Java version. Note that you have to use a 32-bit Java version.


I cannot tell what you mean by 'Go to Extra ->...
ESgt
OpenOffice version 4.1.6
Microsoft Windows 7 Professional, 64bit
User avatar
ESgt
 
Posts: 6
Joined: Sun Apr 17, 2016 6:12 pm
Location: UK Derbyshire

Re: Lost database table and queries

Postby RoryOF » Wed Mar 06, 2019 7:22 pm

Translation problem: try /Tools /Options/ OpenOffice /Java
Apache OpenOffice 4.1.6 on Xubuntu 18.04.2 (mostly 64 bit version) and very infrequently on Win2K/XP
User avatar
RoryOF
Moderator
 
Posts: 28988
Joined: Sat Jan 31, 2009 9:30 pm
Location: Ireland

Re: Lost database table and queries

Postby ESgt » Thu Mar 07, 2019 12:36 am

RoryOF wrote:Translation problem: try /Tools /Options/ OpenOffice /Java


OK, found there: Location: C:\Program Files (x86)\Java\jre1.8.0_191 and see that there is a button for Class Path. With that I set the folder name. But there is no improvement after restating.
ESgt
OpenOffice version 4.1.6
Microsoft Windows 7 Professional, 64bit
User avatar
ESgt
 
Posts: 6
Joined: Sun Apr 17, 2016 6:12 pm
Location: UK Derbyshire

Re: Lost database table and queries

Postby ESgt » Thu Mar 07, 2019 1:04 am

Villeroy wrote:Quick test on the file:
Change the file name extension to .zip instead of .odb. OpenOffice documents are zip archives actually.
If you can open the renamed archive with a zip tool it is rather unlikely that the file is damaged.


OK, made a .zip file copy and opened with WinRAR giving a list of 6 folders and 3 files:
Attachments
odbzipfiles.jpg
ESgt
OpenOffice version 4.1.6
Microsoft Windows 7 Professional, 64bit
User avatar
ESgt
 
Posts: 6
Joined: Sun Apr 17, 2016 6:12 pm
Location: UK Derbyshire

Re: Lost database table and queries

Postby Villeroy » Thu Mar 07, 2019 8:53 am

Troubleshooting Open/LibreOffice and Java
Ignore the class path button. That setting is not relevant for your embedded database.
The zip content looks OK.
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04, no OpenOffice, LibreOffice 6.x
User avatar
Villeroy
Volunteer
 
Posts: 26765
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany


Return to Base

Who is online

Users browsing this forum: No registered users and 4 guests