CODEWITHSUNDEEP
sqlsql-serversql-server-2008sql-server-2008-r2linked-server
SIGIT
SIGIT

Reputation: 21

Linked server error OLE DB provider "SQLNCLI10"

I'm trying to create linked server from server A (sql server 2008) to server B (sql server 2000). I've done to create the linked server connection, but I've got some error when I run query as shown below,

OLE DB provider "SQLNCLI10" for linked server "SERVER_A" returned message     "Unspecified error".
OLE DB provider "SQLNCLI10" for linked server "SERVER_A" 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      "SQLNCLI10" for linked server "SERVER_A". The provider supports the interface,     but returns a failure code when it is used.

Need help.

Upvotes: 2

Views: 8673

Answers (2)

Naveen
Naveen

Reputation: 144

I know this is a very old post. Not sure the issue is been fixed for you or not. But in this blog, they recommended to create this sproc in 2000 server master database. I tried and it worked like a treat for me. 

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
go

Upvotes: 1

Hercule
Hercule

Reputation: 186

I think you have to enable the SQLNCLI10 supplier option only level 0 as SQL 2000 does not support schema conception.

You can enable the option by editing the SQLNCLI10 supplier option and then check the related checkbox.

Hope it helps.

Upvotes: 0

Related Questions