Connecting to multiple databases on SQL Server

[egolan]

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?

[AndreyZ]

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;