We recently separated to companies of out system and put the second one in a different named instance of sql server , now we are facing the problem of a report which gets data from the two companies.

how can i get the data from the two instances, and remeber that getting the data in the actual instance ain't the problem, getting the data from the named instance it is.

some usefull info

we're using ODBC
the two instances reside on the same server

TIA