Re: Connect to multiple datasources

[email protected] wrote:
> is it possible to connec tto multiple databases in JDBC/OOo?
> 
> I got a client that has a sistem that uses MSQuery (an excel subset of 
> db connectivity) and pull info from different databases and dump it into 
> Excel. I wonder if Calc can do the same, the main question is if the 
> datasource can connect from different datasources.
> I know I can register multiple datasources but I am not sure I can 
> connect to them simultaneously, but then again I have never tried and 
> wonder if anyone else here knows.

Hi,
Another thing that works for me: In ordinary office documents, outside 
the Base container, you can bind a form to some datasource's row set and 
a related subform to some other source's row set, so the form looks and 
behaves as if it were connected to one source.