Board index » delphi » Query across 2 SQL 7 Servers?

Query across 2 SQL 7 Servers?

Is it possible to select from one db in to another using ADO?

Example:

 insert into Server1.Database1.Table1 (select * from
Server2.Database2.Table2)

 

Re:Query across 2 SQL 7 Servers?


I believe it depends on support of the host database.  This can be done in
SQL7, not sure about Oracle.  SQL7 can query a DBMS as long as it is added
as a "linked server", but permissions come into play with this.

Quote
accman <acc...@tampabay.rr.com> wrote in message

news:82htgf$fh67@forums.borland.com...
Quote
> Is it possible to select from one db in to another using ADO?

> Example:

>  insert into Server1.Database1.Table1 (select * from
> Server2.Database2.Table2)

Other Threads