If my understanding is correct OPENDATASOURCE or OPENROWSET both use the same concepts of linked server the only advantage is that you dont have to create an explicit Linked server...

I tried going the Linked server route as the Books online suggested that that was the preferred way as opposed to OPENDATASOURCE and OPENROWSET route "for any data sources...