bertrandkis
Programmer
I have installed sql server 2005 on a Windows 2003 box and Created a linked server to link to a SQL2000(SVRFOO) running on Win2000 box. When I try to run this query:
select * from SVRFOO.databasedn.dbo.People
against the linked server I get this message
OLE DB provider "SQLNCLI" for linked server "SVRFOO" returned message "Unspecified error".
OLE DB provider "SQLNCLI" for linked server "SVRFOO" returned message "The stored procedure required to complete this operation could not be found on the server. Please contact your system administrator.".
Msg 7311, Level 16, State 2, Line 1
Cannot obtain the schema rowset "DBSCHEMA_TABLES_INFO" for OLE DB provider "SQLNCLI" for linked server "SVRFOO". The provider supports the interface, but returns a failure code when it is used.
Please help.
select * from SVRFOO.databasedn.dbo.People
against the linked server I get this message
OLE DB provider "SQLNCLI" for linked server "SVRFOO" returned message "Unspecified error".
OLE DB provider "SQLNCLI" for linked server "SVRFOO" returned message "The stored procedure required to complete this operation could not be found on the server. Please contact your system administrator.".
Msg 7311, Level 16, State 2, Line 1
Cannot obtain the schema rowset "DBSCHEMA_TABLES_INFO" for OLE DB provider "SQLNCLI" for linked server "SVRFOO". The provider supports the interface, but returns a failure code when it is used.
Please help.
