Re: [libreoffice-users] Base - using external databases

John

On Wed, 2011-10-12 at 14:52 +0100, jowyta wrote: 

> Regina Henschel wrote
>
> jowyta schrieb:
>
> > > A long unresolved problem with OpenOffice.org base was its
> > > inability to link to more than one external database at a time.
> > > See: http://openoffice.org/bugzilla/show_bug.cgi?id=42464
>
> > > It is for this reason (needing to link to more than one table) that
> > > I have had to use base's internal HQLDB database.
>
> > I don't understand your reasoning. The issue is about connecting to
> > two different databases with the same odb-document. For example
> > connecting to MySQL and PostgreSQL at the same time. That has
> > nothing to do with more than one table. You can have as much tables
> > in a database as you need.
>
> > What is your problem and in which way does the internal HSQLDB helps
> > you?
>
> My problem was that if I had tables in different files, even if they 
> used the same database structure, then base could not link to more than 
> one of them.  This seems to be a facility that various people need.
>
> It might be a solution for me if I could have several tables in the same 
> file provided that I could manipulate them from base rather than having 
> to use a separate database programme.  If this is possible, are there 
> some instructions somewhere as to how to extract the data to a separate 
> file?
>
> Kind regards
>
> John

If I understand your problem you have table in one database and you need
to access from another database. For example you have in MySQL/MariaDB
or PostgreSQL two databases called VendorAccounts and Inventory. Your
query/view/function/etc. must access one table in each to get the
relevant data. (MariaDB is a FOSS fork of MySQL and can easily replace
MySQL)

My first question is what is your backend?

Next how are you connecting to the backend? For example MySQL/MariaDB
have several possibilities depending on the network and database server
location. I have MySQL/MariaDB installed on my desktop and can access it
using direct connection, odbc, and jbdc - I normally use direct
connection.

Also, have you checked the documentation for your backend for the syntax
for querying tables in different databases? MySQL/MariaDB use the SQL
union to do this.

What is your OS and LO version?
-- 
Jay Lozier
jslozier@gmail.com

-- 
For unsubscribe instructions e-mail to: users+help@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