[Solved] Connection to data source could not be established

[martijn]

Hello,

When opening an existing .ODB file, I get the message "connection to the data source could not be established".
I click on the button 'more' and see the errormessage "SQL Status: HY000" and the text "The connection to the external data source could not be established. No SDBC driver was found for the given URL."
There's even more information, it says: "A connection for the following URL was requested: sdbc:embedded:hsqldb", which to me is like Chinese, it sounds delicious, but I cannot make anything of it...

I don't understand it, because I created the file with BASE.

What can I do to solve this problem or save the data already stored in de database?

Martijn

[Villeroy]

Please refer to this forum's Survival Guide

What is your operating system
Java version (if any) used in Menu:Tools>Options...OOo>Java
Office version according to Menu:Help>About...

Are you still able to create a new database via File>New>Database... [X]Create new database ?
Can you load other databases like this one: http://user.services.openoffice.org/en/ ... php?id=649 ?

[martijn]

Hello,

it seemed that java was disabled. I have enabled it an now it works again!
Thanks for giving me this hint.

Martijn

[progsy]

so how do you turn java back on? and how does it get turned off?

[Hagar Delest]

Tools>Options>OOo>Java and make sure there is a version checked.
Sometimes the profile gets corrupted and the option gets lost. Rather rare however.