Informix

 View Only
Expand all | Collapse all

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

  • 1.  [Informix][Informix ODBC Driver]Unspecified System Error = -21005

    Posted Mon February 22, 2021 10:28 AM
    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


  • 2.  RE: [Informix][Informix ODBC Driver]Unspecified System Error = -21005

    IBM Champion
    Posted Mon February 22, 2021 11:15 AM
    -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
    ------------------------------