Discussion of open issues, suggestions and bugs regarding SDAC (SQL Server Data Access Components) for Delphi, C++Builder, Lazarus (and FPC)
- Posts: 1
- Joined: Wed 22 Jun 2011 15:12
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?
You can use the following code:
Code: Select all
MSQuery.SQL.Add('SELECT * FROM dbname1.dbo.tablename');
MSQuery.SQL.Add('SELECT * FROM dbname2.dbo.tablename');