Creating a join on tables in two different MSSQL 6.5 DB's
Quote:
> I need to create a resultset by joining two tables that are in
> different SQL 6.5 databases. This is not a problem with 7.0, but we
> are only working with 6.5 and upgrading is not possible right now.
> I am using VBEE 5.0 and RDO. Any pointers in the right direction would
> be extremely appreciated.
You could try using SQL Server's database.owner.tablename syntax to
refer to the table in the other database, but the other database has
to reside on the same server. Otherwise, you could query against an
Access MDB which contains linked TableDefs pointing to the SQL Server
tables. See DAO's Connect property to see how to do this in DAO. I
have no idea how to do it in ADO, sorry.
--
WARNING: I cannot be held responsible for the above They're coming to
because my cats have apparently learned to type. take me away, ha ha!
