Hello Guys,<BR><BR>I have found a way to access multiple databases, using single connection and single filedsn, i.e. you open a single connection & filedsn in asp file and retrieve data from multiple databases using distributed queries in sql server.<BR><BR>my doubt is "is it the efficient way to do the coding?"<BR><BR>And also, this type of thing works with multiple server .<BR><BR>I never tried with heterogenous databases but tried on 3 servers having sql server.<BR><BR>If anyone possesses any knowledge on this or worked previously, i would like to share with them and clarify my doubts.<BR><BR>thanks<BR>rajpalrao<BR>rajpalrao@re diffmail.com<BR>