SQL Server x64 on a linked server, linked to a database on SQL Server x86, the following error occurred: The OLE DB provider "SQLNCLI10" of the linked server "(NULL)" returned the message "Unspecified error".
The OLE DB provider "SQLNCLI10" of the linked server "(NULL)" returned the message "The stored procedures required to complete the operation cannot be found on this server." Contact your system administrator. "。
Msg 7311, Level 16, State 2, line 1th
Unable to get the schema rowset "Dbschema_tables_info" for the OLE DB provider "SQLNCLI10" of the linked server "(null)". The interface is supported by the provider, but a failure code is returned when the interface is used.create the following stored procedures under the SQL 2k Master Library?
1 2 3 4 5 6 7 |
create procedure sp_tables_info_rowset_64
@table_name sysname,
@table_schema sysname =
null
,
@table_type nvarchar(255) =
null as declare @Result
int set @Result = 0 exec @Result = sp_tables_info_rowset @table_name, @table_schema, @table_type
|
Workaround was found at the following URL: http://social.msdn.microsoft.com/Forums/sqlserver/zh-CN/7b24b699-f8b9-48e8-ba78-b037fd3b1d21/ linked-servers-20002005 There is a workaround for this URL, but I didn't try. Http://support.microsoft.com/kb/906954/zh-cn