Re: [libreoffice-users] Re: Connect Base to External HSQLDB

2014-03-11 Thread jomali
On Mon, Mar 10, 2014 at 9:23 PM, Mark LaPierre marklap...@aol.com wrote: snip Hey Alex, So what you are saying is that I can create a LO Base DB that references tables stored in the standalone HSQLDB database with the JDBC connector, and use that .odb file as a back end to another LO Base

[libreoffice-users] Re: Connect Base to External HSQLDB

2014-03-11 Thread Alex Thurgood
On 11/03/2014 13:23, jomali wrote: Hi John, I think your confusion lies in equating an .odb file with an Access database. The .odb file never contains the data. It is a sort of registry that points to wherever the data is. Thus, Base is the front end, a real database is the back end, and the

[libreoffice-users] Re: Connect Base to External HSQLDB

2014-03-11 Thread Alex Thurgood
On 11/03/2014 02:23, Mark LaPierre wrote: Hi Mark, So what you are saying is that I can create a LO Base DB that references tables stored in the standalone HSQLDB database with the JDBC connector, and use that .odb file as a back end to another LO Base DB which acts as a front end? I've

Re: [libreoffice-users] Re: Connect Base to External HSQLDB

2014-03-11 Thread Tom Davies
Hi :) Yes, quite. So 2 different front-ends (such as Base on different machines or for different purposes) could use the same back-end. Daisy chaining one to another seems like a really bad plan. Fairy lights on Xmas trees used to be daisy-chained which meant that if 1 bulb went out then they

Re: [libreoffice-users] Re: Connect Base to External HSQLDB

2014-03-11 Thread jomali
Thanks, Alex, for the clarification. Since I have never used the internal hsqldb database, I was unaware that it kept its data in the .odb file. The last internal database I used was Adabas D in Staroffice. I quickly went to JDBC or ODBC connectors to other external datbase engines (e.g., MySQL).

Re: [libreoffice-users] Re: Connect Base to External HSQLDB

2014-03-11 Thread Tom Davies
Hi :) I think it's worth avoiding using the internal back-end. Until very recently the internal one was an ancient and heavily tweaked version of Hsqldb. I think the devs have been working at replacing it with a more straight-forward Firebird and hopefully that will be updated in some sort of

[libreoffice-users] Re: Connect Base to External HSQLDB

2014-03-10 Thread Alex Thurgood
Le 04/03/2014 13:53, Mark LaPierre a écrit : Hi Mark, I just now noticed that you have hsqldb:file:path to the.odb in the Datasource URL area. How is a Base, i.e. .odb, file used as the data source when the data is stored in a standalone HSQLDB database? The data is not stored in an .odb

Re: [libreoffice-users] Re: Connect Base to External HSQLDB

2014-03-10 Thread Mark LaPierre
On 03/10/14 09:40, Alex Thurgood wrote: Le 04/03/2014 13:53, Mark LaPierre a écrit : Hi Mark, I just now noticed that you have hsqldb:file:path to the.odb in the Datasource URL area. How is a Base, i.e. .odb, file used as the data source when the data is stored in a standalone HSQLDB

Re: [libreoffice-users] Re: Connect Base to External HSQLDB

2014-02-08 Thread Jean-Francois Nifenecker
Hello Alex, Le 06/02/2014 07:16, Alex Thurgood a écrit : Note that this part didn't work for me on Mac, it provokes an error in LO's component loader or service manager (don't remember which now), or at least, that was the case for 4.0 and 4.1. well... this *did* work fo me under WinXP and

[libreoffice-users] Re: Connect Base to External HSQLDB

2014-02-08 Thread Alexander Thurgood
Le 08/02/14 15:07, Jean-Francois Nifenecker a écrit : Hi Jean-François, all : Having just re-tested with Mac OSX Mavericks, LO 4.2.0.3 and hsqldb 2.2.8, I was able to get this to work :-) Alex -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems?

[libreoffice-users] Re: Connect Base to External HSQLDB

2014-02-05 Thread Alex Thurgood
Le 06/02/2014 06:59, Jean-Francois Nifenecker a écrit : Hi Mark, Jean-François, Once this is set, click Class path In the new dialog: (1) Add an archive Point to the hsqldb.jar on your PC (mine is C:\Program Files\hsqldb-2.2.8.\lib) (2) Add a file Point to the above \lib subdir Note that