How can I open a database created using Open Office in Libre Office?

asked 2020-06-11 17:49:52 +0200

R4L gravatar image

I created a database using Open Office a few years ago and I am generally using Libre Office now. However I cannot open a database that I created using Open Office, in Libre Office. Is there a way that I can do this?

edit retag flag offensive close merge delete

Comments

However I cannot open a database that I created using Open Office

Any error message, when trying to open?

Opaque gravatar imageOpaque ( 2020-06-11 17:56:26 +0200 )edit

Thanks for reponding. Yes, I get an error message: "The connection could not be created. Perhaps the necessary data provider is not installed." At first I thought that Java was not installed properly as I had made changes to my PC, but now I have re-installed java it has made no difference.

R4L gravatar imageR4L ( 2020-06-11 18:51:53 +0200 )edit
1

Hmm - reinstalling 32-bit java while using 64-bit LibreOffice won't help at all, since bitness must match. Hence more information is required to help:

  • Which java did you install 32-bit or 64-bit?
  • Which LibreOffice version do you use and which bitness (32-bit or 64-bit)?
  • Did you assure that LibreOffice found your Java installation (In Tools -> Options -> LibreOffice -> Advanced is Java listed and Location shown)?
  • Did you assure that it is really enabled (Option [x] Use a Java runtime environment)?

And please also mention the operating system you are using and the type of database (embedded HSQLDB?).

Opaque gravatar imageOpaque ( 2020-06-11 19:09:36 +0200 )edit

Hi, I have just checked your queries, and: I have checked that I have installed 64 bit Java 64 bit Libre Office in use I have gone through your Tools etc link and the info says "ticked" Use a Java Runtime environment "Java runtime environment (JRE) already installed" but the location is not shown, and when I try to add the correct directory, I get a message to say that the folder I have selected does not contain a runtime environment. What file should I be looking for? The file I have chosen holds java.exe Operating system is Windows 10 Not sure of the type of database. How do I find out. By the way when I open the database in Open Office (which it does OK) I can find a reference to the JRE Regards,

R4L gravatar imageR4L ( 2020-06-12 12:48:37 +0200 )edit

And you see the installed Java listed in the pane below the option and the radio button activated - similar(!!!) to this screenshot:? (don't mind the details - I'm using Linux).

image description

Opaque gravatar imageOpaque ( 2020-06-12 12:59:22 +0200 )edit

No, there is nothing in the Vendor / Version / Features box. When I try to "add" I lead it to the Jave folder in programs 64, but then I get the message that the folder does not contain a JRE.

R4L gravatar imageR4L ( 2020-06-12 17:59:50 +0200 )edit

When I try to "add" I lead it to the Jave folder in programs 64, but then I get the message that the folder does not contain a JRE

I understood that, but in general it is not required to use Add functionality, since LibreOffice will detect a valid Java installation automatically. If the information doesn't appear of a Java installation automatically, then most likely using Add won't cure an existing problem. Hence:

What exactly did you install?

Please provide

  • Filename of your Java installation package
  • Installation directory (into which path did your Java install)
  • Exact download URL

(It seems definitely to be a problem of your Java installation)

Opaque gravatar imageOpaque ( 2020-06-13 14:58:24 +0200 )edit