Hi,

Thanks a lot for your help, this solution works for me! 🙂

Damn we were already looking for more exotic solutions,

I'm quite happy that we can solve it this way.

Indeed if I run the query distributed with openquery,

and I put To_NChar() around the column that gave the error

it works smoothly. (below the working query)

SELECT *

FROM OPENQUERY(SERV_VISION, 'SELECT LANG_DIV

,WARE_DIV

,CAUSE_CD

,To_NChar(CAUSE_NM) as CAUSE_NM

,UNKNOWN_FLG

,DR_DIV

,CRT_DT

,CRT_ID

,UPD_DT

,UPD_ID

,CLASS_CD1

,CLASS_CD2 from VISION.INV_M008')

Thanks a lot!

Best regards,

Koen