Sorry,

I should give you the error returned by >>

select * from echange.g2mir.dbo.test

The result message is

Serveur : Msg 7399, Niveau 16, État 1, Ligne 1
OLE DB provider 'SQLOLEDB' reported an error. The provider did not give any information about the error.
OLE DB error trace [OLE/DB Provider 'SQLOLEDB' IUnknown::QueryInterface returned 0x80004005:  The provider did not give any information about the error.].

I hope it will help you


>Marc,
>
>There's really a lot of info behind "doesn't work", isn't it? Care to share?
>
>>
>>I created a linked server but I don't understand why the four parts names select doesn't work, while OPENQUERY() works fine
>>
>>Here are the two sample code I used to make test. ECHANGE is my linked server, using OLEDB Provider for SQL Server, G2MIR is the database and TEST is the table
>>
>>

select * from echange.g2mir.dbo.test
>>
>>select * from openquery(echange, 'select * from test')

>>
>>The OPENQUERY returns all datas from my TEST table, It permit me to insert or delete datas, but I'd prefer to use four parts select.
>>