Unanswered: Could not create an instance of OLE DB provider 'SQLOLEDB'
I linked 2 servers together (A linked to B) and they both run SQL 2000. I get the following error when I try to run a query from server A against server B using the 4 part naming convention:
OLE DB error trace [Non-interface error: CoCreate of DSO for SQLOLEDB returned 0x80040154].
Msg 7302, Level 16, State 1, Line 1
Could not create an instance of OLE DB provider 'SQLOLEDB'.
I get the same error when I try to create an ad-hoc link using an open row-set query. The part that throws me off is that when I linked server B to server A, I can query from B to A with no problem. The research that I have done leads me to believe that it is with a DLL or MDAC. Server A is running Windows 2000 with SP 4 and MDAC 2.8. Any direction would be helpful.