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

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 database?  The
> > data is not stored in an .odb file but rather is managed by the
> > standalone HSQLDB database.
>
> The ODB file uses a JDBC connector driver included in the hsqldb
> package, i.e. it merely references the actual database and uses JDBC to
> access it. Any and all forms, queries, reports, macros, etc, are stored
> within the ODB file, even if the actual data from the hsqldb is stored
> in a separate directory pointed to by the URL. Also stored in the
> separate directory is the db initialisation/creation script file and any
> data backup and user/pwd configuration.
>
> This is what we mean by a "split" hsqldb database.
>
> Alex

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 DB which acts as
a front end?  I've read, and been told on this mail list that LO Base
can't do that.  If I could do that I wouldn't need the standalone
HSQLDB, just a plain .odb file with some tables in it.

I've been trying to get this set up for months with no success.  I could
have done all this and more with Microsoft Access in just a few days.
This really shouldn't be this hard.

I think I need someone to hold my hand through the creation of just one
very simple LO Base DB with just two tables in it.


-- 
    _
   °v°
  /(_)\
   ^ ^  Mark LaPierre
Registered Linux user No #267004
https://linuxcounter.net/
****

-- 
To unsubscribe e-mail to: users+unsubscribe@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted