Problem with LibreOffice Base

Questions about applications and software
Forum rules
Before you post please read how to get help
JerryC58
Level 3
Level 3
Posts: 148
Joined: Sun Jul 14, 2013 7:02 pm

Problem with LibreOffice Base

Postby JerryC58 » Thu May 29, 2014 10:22 pm

I am using LibreOffice Base 4.1.3.2 on Mint 16. I use it to keep track of my collection of Jack Daniels bottles. If I remember correctly, this file was created on some version of Base 3 or 4 years ago on some version of Ubuntu. Now when I try to open this database to add some new bottles, i get errors. The first error is "The connection to the data source "Jack Daniel Bottles" could not be established". The second error is "SQL Status: HY000
The connection to the external data source could not be established. No SDBC driver was found for the given URL. An information line states "A connection for the following URL was requested "/home/jc/Documents/Jack Daniel/Jack Daniel/JD Bottles.accdb"". I have made sure the .accdb file is there where it is supposed to be. I suspect the second error where it says no SDBC driver was found is the problem. So I found and installed PostgreSQL SDBC driver. I still get the errors when I try to open my database. Any ideas?
JC
Linux Mint 17.3 Cinnamon

nathant
Level 1
Level 1
Posts: 13
Joined: Sun Sep 04, 2011 2:13 am

Re: Problem with LibreOffice Base

Postby nathant » Mon Jun 02, 2014 3:41 pm

My situation is similar to yours. I have no problem with LibreOffice in Linux Mint 16. Then I upgrade (clean install) to Linux Mint 17. LibreOffice cannot open an existing database. The error is "No SDBC driver was found. A connection for the following URL was requested "sdbc:hsqldb".

I finally figure out that "SDBC HSQLDB" driver is missing. Using Synaptic Package Manager, I install "libreoffice-sdbc-hsqldb". That solves the problem.

Nathan

JerryC58
Level 3
Level 3
Posts: 148
Joined: Sun Jul 14, 2013 7:02 pm

Re: Problem with LibreOffice Base

Postby JerryC58 » Tue Jun 03, 2014 2:41 pm

Sounds reasonable. But when I do a search in Synaptic Package Manager for libreoffice-sdbc-hsqldb, it doesn't find anything. I probably have a missing source. Any idea what it would be?
JC
Linux Mint 17.3 Cinnamon

wilr
Level 1
Level 1
Posts: 1
Joined: Wed Jun 04, 2014 12:09 am

Re: Problem with LibreOffice Base

Postby wilr » Wed Jun 04, 2014 12:13 am

Thanks for bringing me on the right track.

Code: Select all

sudo apt-get install libreoffice-sdbc-hsqldb
in the terminal did the trick for me.

Good luck!

JerryC58
Level 3
Level 3
Posts: 148
Joined: Sun Jul 14, 2013 7:02 pm

Re: Problem with LibreOffice Base

Postby JerryC58 » Wed Jun 04, 2014 11:56 am

Tried that. Said it couldn't find it.
JC
Linux Mint 17.3 Cinnamon

jaygee17
Level 1
Level 1
Posts: 1
Joined: Fri Jun 20, 2014 9:50 pm

Re: Problem with LibreOffice Base

Postby jaygee17 » Fri Jun 20, 2014 10:11 pm

I had the same problem. No sdbc.
Database originally created using libreoffice 4.1.2 in linux mint 16.
Wasn't able to open using libreoffice 4.2.2 in mint 17 - followed "nathant" & "wilr" posts and everything is working great. Thanks fellas.

JC - Use "Update Manager" to find/install "libreoffice-sdbc-hsqldb" Not Synaptic Package Manager
* Seaching in Synaptic Package Manger will only show sdbc-hsqldb if it's installed.
else
open terminal (ctrl+alt+t) then copy and paste the code below --- As previously posted

Code: Select all

sudo apt-get install libreoffice-sdbc-hsqldb


Jeff

JerryC58
Level 3
Level 3
Posts: 148
Joined: Sun Jul 14, 2013 7:02 pm

Re: Problem with LibreOffice Base

Postby JerryC58 » Wed Jun 25, 2014 10:28 am

Like I said before, tried it (terminal method), couldn't find it. Started Update Manager, don't know how to tell it what to look for. Do I need to update or add a repository?

JC
JC
Linux Mint 17.3 Cinnamon

jmpurbeck
Level 1
Level 1
Posts: 13
Joined: Thu Aug 15, 2013 6:32 am

Re: Problem with LibreOffice Base

Postby jmpurbeck » Thu Jun 26, 2014 4:12 am

JerryC58 - you probably need to try
sudo add-apt-repository ppa:libreoffice/ppa
sudo apt-get update

Then retry the install command.

HTH

JerryC58
Level 3
Level 3
Posts: 148
Joined: Sun Jul 14, 2013 7:02 pm

Re: Problem with LibreOffice Base

Postby JerryC58 » Wed Jul 02, 2014 9:46 am

That worked for me but now the error is different from the one in the first post. It reads:

"The connection to the data source "Jack Daniels Bottles" could not be established.

The connection to the external data source could not be established. No SDBC driver was found for the URL '/home/jc/Documents/Jack Daniel/Jack Daniel/JD Bottles.accdb'.

The JD Bottles.accdb file is in that directory.

Any more ideas?

JC
JC
Linux Mint 17.3 Cinnamon

User avatar
Hugh_HH
Level 1
Level 1
Posts: 14
Joined: Sun Jun 01, 2014 6:32 am
Location: Hamburg

Re: Problem with LibreOffice Base SOLUTION

Postby Hugh_HH » Fri Jul 04, 2014 7:48 pm

I had the same problem.
In Mint 17 is only LO base -core- installed. Go to synaptic and install
LO base
LO base drivers

just make sure you have all -three- base packages installed.

Then you can work.
The instructions suggested Windows xp or better, so I installed Linux Mint

JerryC58
Level 3
Level 3
Posts: 148
Joined: Sun Jul 14, 2013 7:02 pm

Re: Problem with LibreOffice Base

Postby JerryC58 » Mon Jul 07, 2014 2:49 pm

I thank everyone for all of the time you have spent with me on this problem, but the time has come to give up. I have tried all of the suggestions as best I could, but nothing has helped. I will start over and recreate my database and see what happens. Again, thank you to everyone.

JC

antcj
Level 2
Level 2
Posts: 81
Joined: Thu Jun 28, 2012 11:17 pm

Re: Problem with LibreOffice Base

Postby antcj » Wed Jul 23, 2014 11:43 pm

Hmm i just had similar issue with base.
anyway after doing all that was suggested above i then discovered that if i go to tools>options>Libreoffice>advanced and make sure that the radio button is ticked for oracle, did the job. (thanks to these guys http://en.libreofficeforum.org/node/1671)
I had the additional issue of not being able to open the db over a network. that is now fixed as well.
Thanks guys.

Cogar
Level 1
Level 1
Posts: 3
Joined: Tue Jul 29, 2014 7:44 pm
Location: USA

Re: Problem with LibreOffice Base

Postby Cogar » Thu Oct 16, 2014 11:42 pm

nathant wrote:My situation is similar to yours. I have no problem with LibreOffice in Linux Mint 16. Then I upgrade (clean install) to Linux Mint 17. LibreOffice cannot open an existing database. The error is "No SDBC driver was found. A connection for the following URL was requested "sdbc:hsqldb".

I finally figure out that "SDBC HSQLDB" driver is missing. Using Synaptic Package Manager, I install "libreoffice-sdbc-hsqldb". That solves the problem.

Nathan

Thank you, Nathan. Worked for me. :D


Return to “Software & Applications”

Who is online

Users browsing this forum: benchrest and 23 guests