Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

"DBSCHEMA_TABLES_INFO" error while querying table in linked server Expand / Collapse
Author
Message
Posted Monday, September 8, 2008 7:15 AM
UDP Broadcaster

UDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP Broadcaster

Group: General Forum Members
Last Login: Today @ 4:25 AM
Points: 1,499, Visits: 2,519
Dear All,
When I try to query one of the table in my linked server am getting the following error.

"Cannot obtain the schema rowset "DBSCHEMA_TABLES_INFO" for OLE DB provider "SQLNCLI" for linked server "linked server".
The provider supports the interface, but returns a failure code when it is used."

Linked server is SQL SERVER 2000 and query is executed from SQL SERVER 2005.

Please help....It's urgent.

Thanks in advance.



Regards,
Santhosh Nair.




Post #565370
Posted Monday, September 8, 2008 7:27 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Monday, August 5, 2013 12:19 PM
Points: 371, Visits: 797
In addition it should be SQL 2005 64 bit edition accessing SQL 2000 32 bit edition.
Easiest solution is:

On SQL 2000 side run the following script:

create procedure sp_tables_info_rowset_64 @table_name sysname, @table_schema sysname = null, @table_type nvarchar(255) = null as declare @Result intselect @Result = 0exec @Result = sp_tables_info_rowset @table_name, @table_schema, @table_type
Post #565381
Posted Monday, September 8, 2008 7:50 AM
UDP Broadcaster

UDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP Broadcaster

Group: General Forum Members
Last Login: Today @ 4:25 AM
Points: 1,499, Visits: 2,519
Hi,

Excellant....Done. It's working now. Thank you somuch..




Thanks,
Santhosh
Post #565409
Posted Saturday, May 29, 2010 9:17 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, June 11, 2013 7:29 PM
Points: 9, Visits: 227
My problem also was solved using the same resolution.

Thank you very much.
Post #930100
Posted Tuesday, November 1, 2011 9:33 AM


Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Saturday, July 5, 2014 12:04 PM
Points: 9, Visits: 90
Excellent!!!! its work's
thanks for you help
Post #1198765
Posted Wednesday, July 31, 2013 7:06 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: 2 days ago @ 10:36 AM
Points: 23, Visits: 412
hi I am getting the same error, but in my case we have SQL 2005 64 bit on both side....

any help...
Post #1479460
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse