Unanswered: Query image data type column using linked server
When running a query like "select * from test.dev.dbo.table_name" using linked server I have got the following error:
OLE DB provider 'SQLOLEDB' reported an error. [SQLSTATE 42000] (Error 7399) OLE DB error trace [OLE/DB Provider 'SQLOLEDB' IRowset::GetNextRows returned 0x80004005: ]
Table contains image column. When quering the same with no image column works fine.
Steps already done:
Reinstalled MDAC 2.7 SP1
Recreated linked server