Page 1 of 1

[Solved] Base's HSQLDB database

Posted: Mon Nov 01, 2010 7:44 am
by Devlei
I am new to Base, but see that when creating a new database it is an embedded database using the HSQL database engine. How do I connect to a HSQLDB database (that was created with HSQLDB Manager) from Base? Alternatively, how does Base store it's database cause I can't seem to find it to open it with HSQLDB Manager?

Re: Base's HSQLDB database

Posted: Mon Nov 01, 2010 11:31 am
by r4zoli
You needs to add under Tools>Options>Java>Classes the hsqldb.jar from your OOo installation \...\Basis\Programs\classes\, to make external connection.
You can not reach OOo Base files from external database tools, without OOo running.

More on Base on wiki page: http://wiki.services.openoffice.org/wiki/Base

Re: Base's HSQLDB database

Posted: Mon Nov 01, 2010 11:40 am
by RPG
Hello

see here

Romke

Re: Base's HSQLDB database

Posted: Fri Nov 05, 2010 4:35 pm
by Devlei
To r4zoli and Romke

Your combined advice was spot on and together with the downloads from fredt article helped me sort the problem out.

Many thanks