[Progress Communities] [Progress OpenEdge ABL] Forum Post: MS SQL Linked Server errors on VARCHAR bigger than 8000

[mstock.speedling.com]

I added the database as a Linked Server in MS SQL, so I can query and use SSMS for all my queries. It's a simple query but the tables has a field with VARCHAR(13255), when the limit in MSSQL is 8000. I cannot find a way to cast, convert, truncate or anything. The query only works if I leave the field out. Msg 7341, Level 16, State 2, Line 43 Cannot get the current row value of column "[PICASQA].[PICAS].[PUB].[crop_note].cn_text" from OLE DB provider "MSDASQL" for linked server "PICASQA". OLE DB provider "MSDASQL" for linked server "PICASQA" returned message "Requested conversion is not supported.".

Continue reading...