Opening 2 databases in one connection

[Niavlys]

Hi,
Is is possible to open 2 databases, from the same SQL server, from just one Connection.

	objConn.Open "Driver={SQL Server};" & _
         		 "Server=10.0.0.18;" & _
   			     "Address=10.0.0.18,1433;" & _
     			 "Network=DBMSSOCN;" & _
           		 "Database= DB1 & _  
           		 "Uid=Username;" & _
           		 "Pwd=Password"

I'm using this DSN less connection type. I need to join data from 1 table in one database with 4 other tables in another database.

Thanks!

 

[AntiEarnie]

I don't know what the SQL server version of this is but in oracle its called a Database Link.