Post reply

"DBSCHEMA_TABLES_INFO" error while querying table in linked server

  • September 8, 2008 at 7:15 am

    #212265

    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.

  • September 8, 2008 at 7:27 am

    #868414

    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

  • September 8, 2008 at 7:50 am

    #868439

    Hi,

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

    Thanks,

    Santhosh

  • May 29, 2010 at 9:17 pm

    #1174285

    My problem also was solved using the same resolution.

    Thank you very much.:-)

  • November 1, 2011 at 9:33 am

    #1401703

    Excellent!!!! its work's :w00t:

    thanks for you help

  • July 31, 2013 at 7:06 am

    #1637361

    hi I am getting the same error, but in my case we have SQL 2005 64 bit on both side....

    any help...

Viewing 6 posts - 1 through 5 (of 5 total)

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