I have two different databases (both MS SQL Server) where I search for employees:
conn1.ConnectionString = (connectionstring to db on server 1)
conn2.ConnectionString = (connectionstring to db on server 2)
sqlstr="SELECT employee.name FROM db_on_server1
WHERE employee.id IN (SELECT persons.id FROM db_on_server2 WHERE ...)"
Set rs = Server.CreateObject("ADODB.Recordset")
rs.open sqlstr, conn1
Works fine when the two databases was on the same SQL server with just one connection string, but now one of them was moved to another server.
Is it possible to subquery like above, when the subquery targets a db on another server, or is there another way of doing this?