Post reply

SQLNCLI error using linked servers

  • June 16, 2010 at 12:05 pm

    #223908

    so i'm running this on a sql 2008 box. It's using linked server to pull all the tables from a db called c-tab. When i run this

    "SELECT *

    FROM [MYAPDB12].[c-tab].INFORMATION_SCHEMA.Tables WHERE TABLE_TYPE = 'BASE TABLE' "

    from the 2005 box i get the error below.

    ----+++++++++++++++++++

    Msg 7314, Level 16, State 1, Line 1

    The OLE DB provider "SQLNCLI" for linked server "MYAPDB12" does not contain the table ""c-tab"."INFORMATION_SCHEMA"."Tables"". The table either does not exist or the current user does not have permissions on that table.

    --+++++++++++++++++++++

    However when i run this i get results returned

    SELECT *

    FROM [MYAPDB12].[c-tab].dbo.Affstats

  • June 16, 2010 at 12:22 pm

    #1181222

    I needed to do something similiar and based on my research you can not access information_schema context in a linked server. every forum I visited ended in the same resolution. you must create a veiw on the linked server and then reference that veiw.

    Dan

    If only I could snap my figures and have all the correct indexes apear and the buffer clean and.... Start day dream here.

  • June 16, 2010 at 3:00 pm

    #1181288

    Figures.

    I'll get the data from a different sys table.

    Thanks for your response.....

Viewing 3 posts - 1 through 2 (of 2 total)

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