I am trying to connect to multiple databases on different servers. HOw can I do this ? Is there online reference or book I can consult. Need it ASAP.

If one of them is a SQL server database then you can either use linked servers or use connection strings in OPENROWSET similar to how you use them in ADO. I use this technique for running a query which joins a table from a SQL Server DB with one from an Oracle DB. Serach for OPENROWSET on msdn or use SQL Server Books OnLine help.

--

Joe