We use the ODBC in a linked server created in MS SQL Server.
Recently we upgraded from the 143 version ODBC driver to the 158 driver.
using the 143 driver we could query item.subsidiary and it would return a comma separated concatenated string containing the internal IDs. with the 153 driver howver we get the 'requested conversion is not supported' error message. Also running queries on for example location.fullname columns returns the same error message is we don't encapsulate in to_char.
Did anyone have the same issue and did you find a solution?