Post reply

Linked server error in SQL Server 2005

  • April 22, 2010 at 2:49 am

    #220784

    Hi Every One,

    I am trying to execute two views from a linked server "Server2" to the server "Server1".

    Both the views working fine in the past.Suddenly the second view started giving error when executing.

    The error message is here

    "OLE DB provider "SQLNCLI" for linked server "Server1" returned message "Binding information is invalid.

    Msg 7346, Level 16, State 2, Line 1

    Cannot get the data of the row from the OLE DB provider "SQLNCLI" for linked server "Server1"."

    Any help pls?

    /Dhayanithy

    Thanks in advance.

  • April 22, 2010 at 10:27 am

    #1156290

    Maybe the error could be the schema, could you put your script that you use?, in this link explain how works the schemabinding

    http://sqllearnings.blogspot.com/2008/11/schema-binding-views.html

    I hope that will help

    that you have a nice day

    Angel Miranda Nieto
    DBA Specialist, BI, MCSA SQL Server

  • April 22, 2010 at 11:39 pm

    #1156611

    Hi Rookie,

    Thanks for the reply.

    I have fixed the error. It was a defined data length(NVARCHAR(MAX)) for conversion from int to nvarchar, caused the issue in a internal view.

    I have modified the definition to NVARCHAR(100) and it solved the issue.

    Now I am able to get data from the view through Linked server.

    Regdars

    Dhayanithy

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

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