Linked Server (Sql7 <--> Sql7) Error: 7302 SQLOLEDB

[SM]

In linking two Sql Server 7.0 boxes, I can reproducibly create a linked server in each (to the other Server). With server B I can run distributed queries on server A with the greatest of ease.

I can create a similar link on server A, however distributed queries on it run as follows:

EXEC LinkedServerB.master.dbo.sp_who
___________________________________________

Msg 7302, Level 16, State 1, Line 1
Could not create an instance of OLE DB provider &#39;SQLOLEDB&#39;.

Does anyone have any idea what could be amiss?

[Jagan]

There are several restictions on linked servers. Go through &#34;Linked Servers&#34; from SQL 7 Online Books and you will know what all about.