Certo che puoi connetterti a due database.
Instanzi due oggetti connessione con due nomi oggetto diversi e recuperi i dati.
codice:
set conn1 = server.createObject("ADODB.Connection")
conn1.open ...

set conn2 = ...
conn2.open ...

sql1 = "SELECT * FROM tabellaNewsFoografia"
sql2 = "SELECT * FROM tabellaNewsWebmarketing"

set rs1 = conn1..execute(sql1)
if not rs1.eof then
...
end if

rs1.close
set rs1 = nothing

set rs2 = conn2.execute(sql2)

if not rs2.eof then
...
end if

rs2.close
set rs2 = nothing

conn1.close
set conn1 = nothing

conn2.close
set conn2 = nothing