Ask Your Question

How to query multiple Databases in different servers? [closed]

asked 2014-06-20 15:38:30 +0200

marcotabuas gravatar image

Can anyone say how do I connect/merge in a query multiple databases in different servers? The "database wizard" gives me only the option to connect to a single database (I am using ODBC).

A query syntax example would be very helpful if possible.

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2016-02-26 22:18:27.624970


Does ODBC support connecting to multiple servers simultaneously? Could you add something about your goals? I guess this is just not possible in the database support that is pretty extensive for an office suite, though limited compared to custom applications that have been programmed to query different databases. There may be different solutions to your problem.

bencomp gravatar imagebencomp ( 2014-06-23 19:23:30 +0200 )edit

I would like to query something like: "SELECT * FROM server1.dbx.table-a and server2.dby.table-b"

marcotabuas gravatar imagemarcotabuas ( 2014-06-26 11:59:18 +0200 )edit

I've been looking for this as well - unfortunately does not seem possible with current Base - MS access has had this for the 16 years at least also i am sure I have seen similar with crystal reports. personally i stick with access for adhoc queries and data manipulation and loading it up to main db server. As it support several back ends u would think Base was functioning as an abstraction layer so would be feasible but i guess it is a 'won't fix' type of feature request Yes i'd like to see it!

MRH gravatar imageMRH ( 2016-10-17 23:28:51 +0200 )edit

1 Answer

Sort by » oldest newest most voted

answered 2014-06-26 22:40:37 +0200

bencomp gravatar image

LibreOffice does not support connecting to multiple databases via ODBC at the same time. So in short: you can't.

In general, applications (in this case your Base file) do not query tables spread across multiple databases on different servers in one query. Data from different databases is first gathered and normalised and put in one database schema by the data abstraction layer or an application built especially for doing this.

edit flag offensive delete link more

Question Tools

1 follower


Asked: 2014-06-20 15:38:30 +0200

Seen: 1,638 times

Last updated: Jun 26 '14