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 ?
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 ? 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]
