I have setup a linked server from a SQL 2000 Standard Edition, 8.00.760 (SP3) to a SQL 2005 Standard Edition 64-bit 9.00.2047.00 and used "Microsoft OLE DB Provider for SQL Server".
It could work fine on all databases but except one :
Server: Msg 7313, Level 16, State 1, Line 1
Invalid schema or catalog specified for provider 'SQLOLEDB'.
OLE DB error trace [Non-interface error: Invalid schema or catalog specified for the provider.].
The linked server worked fine and no problem on the other databases of the same server.
But always got the above error when I connected to one of my database.