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 43Cannot 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.".
You can try Authorized Data Truncation (-SQLTruncateTooLarge OUTPUT) if you use OpenEdge latest version
Russian Progress User Group
Thanks and Regards,
Lead Principal Software Engineer
Progress Software Development Private Ltd.
Valeriy Bashkatov Is that something I can configure on the MS SQL Server Linked Server? I don't much access to the configuration of the DB, I'm just consuming as a read-only client.
Avadhoot Kulkarni I'm using Progress OpenEdge 11.7 Driver, which was installed by our system developer. I've asked them about this issue but they didn't have many suggestions.
Where can I set the MVS option on the ODBC? The only place I can think of is on the Advance\Extended Options. See screenshot below.
Sorry, this option is not implemented for OpenEdge driver.
One approach I can suggest you is to, Create a Views with casting the long columns to VARCHAR (8000) and then use those views in your SQl Server Linked Server environment.
Hope that helps!
Enter "truncateTooLarge=on" or "truncateTooLarge=output" in the Extended Options field. Remember this setting is case sensitive. The parameter is connection specific and is remembered by SQL only during the connection session.
Valeriy Bashkatov Same result. I tried with ON, OUTPUT and ALL.
My recommendation was based on this article from ProKB:
According to the information in this article this should work for OpenEdge starting from version 11.5.
What version of the OpenEdge database do you have (not the ODBC driver version)?
I think you need to contact Progress Technical Support for a more detailed investigation of your problem.
Well, the article says OpenEdge 11.5.x and 11.6.x, but we are on 11.7. Not sure if that means our version is included too.