Post reply

linked Server from sql server 2005 (64 bit) to sql server 2000

  • July 19, 2008 at 4:30 am

    #122422

    I am getting this error when i am giving the select command on the linked server(easyerpqa1) does any have a solution for this.

    OLE DB provider "SQLNCLI" for linked server "easyerpqa1" returned message "Unspecified error".

    OLE DB provider "SQLNCLI" for linked server "easyerpqa1" 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 "easyerpqa1". The provider supports the interface, but returns a failure code when it is used.

  • July 19, 2008 at 7:39 am

    #845328

    Yes i had the exact same error until i loaded the Cumlative 6 updated for SQL 2005 without this it would give the errors below - i could not link back to sql 2000 at all and vice versa.

    Load the lastest updates patches for SQL 2005.

Viewing 2 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply