Devart Forums

Posted: **Wed 22 Jun 2011 15:30**

I'm using Delphi 7 and SDAC to connect to Microsoft SQL Server.
When using MSQuery I like to retrieve data from multiple Databases. Does anybody know how to do that?

Posted: **Thu 23 Jun 2011 12:12**

Hello,

You can use the following code:

Code: Select all

MSQuery.SQL.Clear;
MSQuery.SQL.Add('SELECT * FROM dbname1.dbo.tablename');
MSQuery.SQL.Add('UNION');
MSQuery.SQL.Add('SELECT * FROM dbname2.dbo.tablename');
MSQuery.Open;

Devart Forums

Connecting to multiple databases on SQL Server

Connecting to multiple databases on SQL Server