Hi All,

I have 2 SQL servers ( A & B ) running on two different boxes :

Server A is SQL 2000
Server B is SQL 7

I need to run a distributed query on server A which access the data from
server B. I am trying to add the linked server ( server B ) on A. I am
getting following error :

Error 7399: OLE DB provider 'SQLOLEDB' reported an error. OLE DB error
trace [OLE/DB Provider 'SQLOLEDB' IDBInitialize::Initialize returned
0x80004005: ].

I never added SQL 7 as a linked server on SQL 2000. Home to deal with
above error? Any suggestion or comments are appreciated.

Thanks ...







MS Sql Server LazyDBA home page