>Sergey,
>
>when I try the 4-part naming I get following error:
>OLE DB provider 'MSDASQL' reported an error. The provider did not give any information about the error.
>
>I tried with a simple query like 'select * from LS.LS..table1'
Hans,
Is this table a free table or a part of DBC? The four part reference will only work for a table in DBC. For a free table try
SELECT * FROM openquery(ls, 'select * from table1')
--sb--