[Informix][Informix ODBC Driver]Unspecified System Error = -21005

OLE DB provider "MSDASQL" for linked server "linkserver" returned message "[Informix][Informix ODBC Driver]Unspecified System Error = -21005.". Msg 7330, Level 16, State 2, Line 1 Cannot fetch a row from OLE DB provider "MSDASQL" for linked server "linkserver". it is running and fetching till 15:16 seconds later giving me this error. ------------------------------ bhimagonolla sureshgoud ------------------------------ #Informix

-21005 is a character conversion error and usually results from incompatible codesets between the server and client: $ finderr 21005-21005 Inexact character conversion during translation. One or more characters were translated using a substitution character. Translation in the reverse direction would not produce the original string. Make sure that the values of the CLIENT_LOCALE and DB_LOCALE environment variables are compatible. Is it possible the the SQL Server 2005 and SQL Server 2019 are using different codesets? Art ------------------------------ Art S. Kagel, President and Principal Consultant ASK Database Management Corp. www.askdbmgt.com ------------------------------