Bug 93538 - FILEOPEN Base: The connection to the data source "<DB name>" could not be established.
Summary: FILEOPEN Base: The connection to the data source "<DB name>" could not be est...
Status: RESOLVED INSUFFICIENTDATA
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Base (show other bugs)
Version:
(earliest affected)
4.4.5.2 release
Hardware: x86-64 (AMD64) Windows (All)
: high critical
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2015-08-19 18:25 UTC by zevski
Modified: 2019-01-17 07:41 UTC (History)
5 users (show)

See Also:
Crash report or crash signature:


Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description zevski 2015-08-19 18:25:45 UTC
I just upgraded to LibreOffice 4.4.5, and when I tried to open my database, I got the above error. When I click on "More" I get two more errors:

1. Error code: 1000

The driver class '' could not be loaded.

2. SQL Status: HY000

The driver class '' could not be loaded.

I tried opening my database from a backup, and got the same error, but when I click on more I get one other error:

1. SQL Status: S1000
Error code: -40

General error: org.hsqldb.lib.FileSystemRuntimeException: java.io.IOException:
Comment 1 Julien Nabet 2015-08-19 19:46:55 UTC
Which precise java version do you have? 1.7, 1.8... 32 or 64bits?

Indeed, if you installed LO 32 bits, you must have a Java 32 bits.
Comment 2 Alex Thurgood 2015-08-20 12:43:54 UTC
@zevski : please specify which bit verison of LibreOffice you are using, and which bit version of Java you have installed.
Comment 3 zevski 2015-08-20 14:46:56 UTC
I have LibreOffice_4.4.5_Win_x86 installed. I have Java 8 update 60, both 32 and 64 bit installed. 

The weird thing is that I am able to view an older backup of the database file, but not the most recent version. I guess the most recent database file may have gotten corrupted?
Comment 4 Alex Thurgood 2015-08-20 17:17:58 UTC
(In reply to zevski from comment #3)
> I have LibreOffice_4.4.5_Win_x86 installed. I have Java 8 update 60, both 32
> and 64 bit installed. 
> 
> The weird thing is that I am able to view an older backup of the database
> file, but not the most recent version. I guess the most recent database file
> may have gotten corrupted?

Sounds like it. Any chance you can upload the unopenable database file to this bug report so we can take a look ? If it is indeed generally corrupted, it won't be openable on other OSes either.

Ideally, having both the functional and non-functional versions of the file might enable us to find out where things have gone wrong.
Comment 5 zevski 2015-08-21 17:17:29 UTC
Sadly, I cannot upload the files as they contain sensitive data. However, I tried opening them on my Linux box and indeed, the older backup opened fine, but the new one got the same error. This leads me to believe it is definitely corrupted, but I don't know what may have caused it.
Comment 6 Robert Großkopf 2015-12-05 10:31:40 UTC
(In reply to zevski from comment #5)
> Sadly, I cannot upload the files as they contain sensitive data. However, I
> tried opening them on my Linux box and indeed, the older backup opened fine,
> but the new one got the same error. This leads me to believe it is
> definitely corrupted, but I don't know what may have caused it.

Hi zevski,

have you tried to open a copy of the damaged file with a packager? Could be you are able to extract the database-files.

You could have a look here:
https://wiki.documentfoundation.org/images/e/e8/BH40-BaseHandbook.pdf
Page 253 might be useful.
Comment 7 Alex Thurgood 2016-06-03 07:26:15 UTC
Per comments 3 and 5, we won't get a file to test with, and a previous version of the file can be opened - closing as INSUFFICIENTDATA