Single Connection String for Multiple Databases ??

Even if you are connected to one databse, you can retrive data from other database tables. For that you need to mention DSN name.

<Database Name>.dbo.<Table Name>

Ex:-

If i am in database1 and i want to access table in database 2 then, query will be
select * from database2.dbo.table1