468,133 Members | 1,439 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 468,133 developers. It's quick & easy.

getting problem while inserting using linked server

4
Hi ,
My requirement is to read and write the data from remote SQL SERVER.
Locally i have SQL SERVER and i want read and write the data from remote SQL SERVER.

I am able to read the data from remote SQL SERVER but i am getting the following error while inserting.

I created one linked server in my machine and mentioned the remote server name as data source.

The query is :

INSERT INTO OPENQUERY(DPVNEWLINK1, 'SELECT * from hyi3w131.SQLDPV.dbo.SAMPLEHAF') values(11,12);

The error is:
Msg 7356, Level 16, State 1, Line 1
The OLE DB provider "SQLNCLI" for linked server "DPVNEWLINK1" supplied inconsistent metadata for a column. The column "ROWID" (compile-time ordinal 1) of object "SELECT * from hyi3w131.SQLDPV.dbo.SAMPLEHAF" was reported to have a "Incomplete schema-error logic." of 0 at compile time and 0 at run time.


Please suggest me regarding this.
Thanks in Advance,
Hafeez.
Sep 26 '06 #1
0 1899

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

303 posts views Thread by mike420 | last post: by
1 post views Thread by gcdp | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.