Has anyone out there done this before without using access? I am trying to join table A from db1 with table B from db2 with ADO. Am having difficulty locating documentation/examples on this type of operation. I don't know how to get around the need for an individual connection string for each db. Thanks for your help.
Travis
Mon, 02 Sep 2002 03:00:00 GMT
Developer #2 / 2
Joining two tables from different dbs
well I've done it using sql server 7.. using the openRowSet method
Quote:
> Has anyone out there done this before without using access? I am trying to > join table A from db1 with table B from db2 with ADO. Am having difficulty > locating documentation/examples on this type of operation. I don't know how > to get around the need for an individual connection string for each db. > Thanks for your help.
Joining two tables from different dbs