chuck wrote:
> I'm trying to link from sql2005 (64-bit) to sql 7 (32-bit).
> I get the following error:
>
> OLE DB provider "SQLNCLI" for linked server "sql7" returned message
> "Unspecified error".
> OLE DB provider "SQLNCLI" for linked server "sql7" 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 3
> Cannot obtain the schema rowset "DBSCHEMA_TABLES_INFO" for OLE DB provider
> "SQLNCLI" for linked server "sql7". The provider supports the interface, but
> returns a failure code when it is used.
>
> I have linked from sql2005 (32-bit) to sql7 (32-bit) successfully.
>
> I haven't seen a 32-bit provider in the New Linked Servers "Other data
> source".
>
> How can I get these servers linked?
>
> --
> Regards,
> chuck