>From: Boris Ratak [mailto:[EMAIL PROTECTED] > >>> 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? > >"jdbc:as400://server_ip/base1" is a correct string to connect Base to an AS400 >via JDBC. I tested it several times and it works, at least enough to show you >one base. But as I said, I read somewhere that you could overload the >connection string by specifing several bases/connection at the same time. I >was trying to figure out how, but I guess OpenOffice just drops the rest of >the string, as I get a "extra connection informations discarded". > >Thanks for taking some time to answer me. I didn't answer right away to your >last e-mail, because I was busy trying another approach : I installed the >AS400 ODBC driver and extra softwares and I set up an ODBC connection using >this piece of software. If you want to use several databases at the same time >in Base, just create a new ODBC connection (user or system) and you can >specify the main base, and the extra bases you want to connect to, separated >by whitespaces. >Then, if you create a new database using this new ODBC connection, you'll see >all the bases you specified. > >I wish I could have used the JDBC driver, but it seems less complete than the >ODBC one. I don't know if anyone have or will have this kind of problem, but >just in case, I wanted to post this message. > >Thanks > >B. >
Hello Boris, Actually this type of information regarding the ODBC connection to several libraries is precisely the type of thing that would make an excellent addition to the Wiki - is there any chance I could talk you into making such a contribution. If you aren't comfortable with creating/updating wiki pages I can put in touch with the Base wiki doku volunteers and I am sure they would assist. ( It's so easy to volunteer other peoples time isn't it :>) Anyway - I really would hope you consider it. Thanks much Drew --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
