Getting error while inserting the rows using linkedserver

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • hafeez
    New Member
    • Sep 2006
    • 4

    Getting error while inserting the rows using linkedserver

    Hello All,
    I created two database instances in the same MS SQL SERVER 2005 named hafeez and local. I created a linked server from hafeez database to local named HTOL

    I created a dummy table in local database named samplocal.

    Now i am able to list the records using the linked server, for this i used the following query.

    SELECT * FROM OPENQUERY(HTOL, 'SELECT nameandval FROM SAMPLOCAL');

    Now the problem is, i am not able to insert the rows into the samplocal table using linkedserver. I am using the following query to insert the rows and getting the following errro.

    INSERT INTO OPENQUERY(HTOL, 'SELECT nameandval FROM SAMPLOCAL') VALUES('tertert etttwertw');

    Msg 7356, Level 16, State 1, Line 1
    The OLE DB provider "SQLNCLI" for linked server "HTOL" supplied inconsistent metadata for a column. The column "nameandval " (compile-time ordinal 1) of object "SELECT nameandval FROM SAMPLOCAL" was reported to have a "Incomplete schema-error logic." of 0 at compile time and 0 at run time.

    Is the above query correct? or shall i miss anything?

    Please guide me.

    Thanks in Advance
    Hafeez Shaik.
Working...