Problem with LibreOffice Base

Questions about applications and software
Forum rules
Before you post please read this

Problem with LibreOffice Base

Postby JerryC58 on 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 16
JerryC58
Level 2
Level 2
 
Posts: 62
Joined: Sun Jul 14, 2013 7:02 pm

Linux Mint is funded by ads and donations.
 

Re: Problem with LibreOffice Base

Postby nathant on 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
nathant
Level 1
Level 1
 
Posts: 13
Joined: Sun Sep 04, 2011 2:13 am

Re: Problem with LibreOffice Base

Postby JerryC58 on 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 16
JerryC58
Level 2
Level 2
 
Posts: 62
Joined: Sun Jul 14, 2013 7:02 pm

Re: Problem with LibreOffice Base

Postby wilr on 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!
wilr
Level 1
Level 1
 
Posts: 1
Joined: Wed Jun 04, 2014 12:09 am

Re: Problem with LibreOffice Base

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

Tried that. Said it couldn't find it.
JC
Linux Mint 16
JerryC58
Level 2
Level 2
 
Posts: 62
Joined: Sun Jul 14, 2013 7:02 pm

Re: Problem with LibreOffice Base

Postby jaygee17 on 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
jaygee17
Level 1
Level 1
 
Posts: 1
Joined: Fri Jun 20, 2014 9:50 pm

Re: Problem with LibreOffice Base

Postby JerryC58 on 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 16
JerryC58
Level 2
Level 2
 
Posts: 62
Joined: Sun Jul 14, 2013 7:02 pm

Re: Problem with LibreOffice Base

Postby jmpurbeck on 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
jmpurbeck
Level 1
Level 1
 
Posts: 9
Joined: Thu Aug 15, 2013 6:32 am

Re: Problem with LibreOffice Base

Postby JerryC58 on 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 16
JerryC58
Level 2
Level 2
 
Posts: 62
Joined: Sun Jul 14, 2013 7:02 pm

Re: Problem with LibreOffice Base SOLUTION

Postby Hugh_HH on 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 8 or better, so I installed Linux Mint
Hugh_HH
Level 1
Level 1
 
Posts: 6
Joined: Sun Jun 01, 2014 6:32 am

Re: Problem with LibreOffice Base

Postby JerryC58 on 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
JerryC58
Level 2
Level 2
 
Posts: 62
Joined: Sun Jul 14, 2013 7:02 pm

Re: Problem with LibreOffice Base

Postby antcj on 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.
antcj
Level 2
Level 2
 
Posts: 52
Joined: Thu Jun 28, 2012 11:17 pm

Linux Mint is funded by ads and donations.
 

Return to Software & Applications

Who is online

Users browsing this forum: No registered users and 12 guests