I see others having this problem when trying to run a query across a link from 2005 to a 2000 server. But we are already running SP4 on our 2000 server. What gives?
OLE DB provider "SQLNCLI" for linked server "s-1" returned message "Unspecified error".
OLE DB provider "SQLNCLI" for linked server "s-1" 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 5
Cannot obtain the schema rowset "DBSCHEMA_TABLES_INFO" for OLE DB provider "SQLNCLI" for linked server "s-1". The provider supports the interface, but returns a failure code when it is used.
Is your server 64-bit? There was a discussion of that case http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=62887&SiteID=1|||64 bit. And I have tested the link against several sql server 2000 instances which report they are all SP4 buy yield the same error messages.
No comments:
Post a Comment