servers

Hi Guys
I am trying to create a linked server from an SQL 2000 to and SQL 2005.
It creates fine but when I expand the Linked Server node and click eg tables
I get the following error:
Error 7302: Could not create an instance of OLE DB provider'Csp'.
OLE DB error trace [Non-interface error: CoCreate of DSO for Csp returned
0x80040154].
Any ideas?
Thanks.
Regards
Jonas
I deleted the linked server.
Opened SQL Server 2005 Management Studio. Connected to my SQL 2000 server
and recreated the linked server - and that was the fix.
Regards
Jonas
"Jonas Larsen" wrote:

> Hi Guys
> I am trying to create a linked server from an SQL 2000 to and SQL 2005.
> It creates fine but when I expand the Linked Server node and click eg tables
> I get the following error:
> Error 7302: Could not create an instance of OLE DB provider'Csp'.
> OLE DB error trace [Non-interface error: CoCreate of DSO for Csp returned
> 0x80040154].
> Any ideas?
> Thanks.
> Regards
> Jonas