Getting error while inserting the rows using linkedserver

[rmiao]

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

Replace schema with real schema name. By the way, how did you create linked server? How did you map sql logins on linked server?