Can you confirm table name, make sure there is no special character (blank space or tab) exists at the end of “Tabledivcomer”.

If blank space exists at the end of “Tabledivcomer”( like “Tabledivcomer ”) then select query will work for local connection (Select * from Tabledivcomer ), but through error if you execute for remote connection Select * FROM LNK.DIVCOMERCIAL.DBO.Tabledivcomer.

In that case you can try Select * FROM LNK.DIVCOMERCIAL.DBO.[Tabledivcomer ]

Nirmal