Boris Ratak wrote:
Thank you for answering my question. I've been reading your e-book about Base
and found a lot of stuff about connecting to an external base. But a question
remains : If I automatically (like via an autostart macro) connect to my three
databases, will they appear in Base's GUI ?
No. If you want to use the data from multiple connections, I expect that
you would need to manually set data in the GUI. I might be wrong, of
course. Drew can probably speak authoritatively to this (If you compare
what he understands about base to what I understand, I am not worthy to
polish his shoes - and he is a nice guy <grin>).
By the way, I've also been trying to change the connection string to use something like
"jdbc:as400://server_ip/base1;jdbc:as400://server_ip/base2" (i've tried several
syntaxes), but I have an error msg saying that the extra connection parameters are
ignored. Am I missing something or is it specific to OOo Base ?
Ummm. Ummmm. I needed to look that up.... You are setting
protocol to jdbc
sub-protocol to as400
Is that a valid sub-protocol?
Boris
--- En date de : Dim 9.11.08, Andrew Douglas Pitonyak <[EMAIL PROTECTED]> a
écrit :
De: Andrew Douglas Pitonyak <[EMAIL PROTECTED]>
Objet: Re: [users] Multiple libraries with OOo Base & AS 400 ?
À: [email protected]
Date: Dimanche 9 Novembre 2008, 5h01
Boris Ratak wrote:
Hi,
I'm using OpenOffice Base to connect to our AS400 server through JDBC.
It works fine, but there's only one problem : We have three libraries
(databases) and in the connection string, I have to specify one of them. Current
library is displayed and I can access the other two using some text requests.
What I would like, is to have all three databases shown in Base GUI, to be able
to select tables from any of the libraries using the common interface.
So basically, I'm using three separate OOBase files to show each
library structure.
Is it possible to have all libraries displayed ? I thought of specifying
my three libraries in the connection string, but I don't know if it's
possible and what the syntax is.
Anyone an idea ?
I expect that you would need to use macros to open individual connections. I
think that it could be a lot of work.
-- Andrew Pitonyak
My Macro Document: http://www.pitonyak.org/AndrewMacro.odt
My Book: http://www.hentzenwerke.com/catalog/oome.htm
Info: http://www.pitonyak.org/oo.php
See Also: http://documentation.openoffice.org/HOW_TO/index.html
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
--
Andrew Pitonyak
My Macro Document: http://www.pitonyak.org/AndrewMacro.odt
My Book: http://www.hentzenwerke.com/catalog/oome.htm
Info: http://www.pitonyak.org/oo.php
See Also: http://documentation.openoffice.org/HOW_TO/index.html
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
