Topic
  • 5 replies
  • Latest Post - ‏2012-03-24T00:26:25Z by ldubois
JuanTorre
JuanTorre
4 Posts

Pinned topic Conversion error €

‏2012-03-07T13:00:04Z |
HI,

I´m developing an aplication in .NET (C#) and I have a small problem with € character.

I can`t INSERT this character in as400 DB2!!!

the adapter always returns same error "conversion error".

I had tried with ODBC and IBM.Data.DB2.iSeries Data Provider and the error is the same.

However if i use the as400 console and "strsql" the Insert works....

Thanks.
Updated on 2012-03-24T00:26:25Z at 2012-03-24T00:26:25Z by ldubois
  • SystemAdmin
    SystemAdmin
    2826 Posts

    Re: Conversion error €

    ‏2012-03-07T15:47:49Z  
    Can you please post the code snippet showing how you're inserting the character. Also, please post the as400 version you're working with and the column definition into which you're trying to insert. Please post the exact error you're getting as well.

    Thanks,
    Alex
  • JuanTorre
    JuanTorre
    4 Posts

    Re: Conversion error €

    ‏2012-03-07T16:50:41Z  
    Can you please post the code snippet showing how you're inserting the character. Also, please post the as400 version you're working with and the column definition into which you're trying to insert. Please post the exact error you're getting as well.

    Thanks,
    Alex
    ODBC
    this.odbcDataAdapter.Update(ds); (ds is a dataset)

    And the another provider (.NET iseries)

    this.iDB2DataAdapter1.Update(ds.Tables[0]);
    AS400 i5 , V6R1 iseries access , the columns are char o varchar (the error is the same)

    "Error de conversion" (conversion error), messagecode 6107
  • SystemAdmin
    SystemAdmin
    2826 Posts

    Re: Conversion error €

    ‏2012-03-07T17:04:48Z  
    • JuanTorre
    • ‏2012-03-07T16:50:41Z
    ODBC
    this.odbcDataAdapter.Update(ds); (ds is a dataset)

    And the another provider (.NET iseries)

    this.iDB2DataAdapter1.Update(ds.Tables[0]);
    AS400 i5 , V6R1 iseries access , the columns are char o varchar (the error is the same)

    "Error de conversion" (conversion error), messagecode 6107
    Are you using iAccess .NET provider or IBM Data Server Provider for .NET and what version of the provider are you using?
  • JuanTorre
    JuanTorre
    4 Posts

    Re: Conversion error €

    ‏2012-03-07T17:10:44Z  
    Are you using iAccess .NET provider or IBM Data Server Provider for .NET and what version of the provider are you using?
    I use iAccess .NET provider V6R1 SI41053 ( and i use the two option ODBC and the new iDb2Connection, IBM.Data.DB2.Iseries DLL version 12.0.0.0)
    what´s IBM Data Server Provider for .NET? its another provider? whats is the difference??
  • ldubois
    ldubois
    61 Posts

    Re: Conversion error €

    ‏2012-03-24T00:26:25Z  
    • JuanTorre
    • ‏2012-03-07T17:10:44Z
    I use iAccess .NET provider V6R1 SI41053 ( and i use the two option ODBC and the new iDb2Connection, IBM.Data.DB2.Iseries DLL version 12.0.0.0)
    what´s IBM Data Server Provider for .NET? its another provider? whats is the difference??
    What is the host ccsid of the column you're trying to insert the data into? What locale settings are you running under in your application? Generally conversion problems like this are either caused by trying to insert something into a ccsid that doesn't have that character, or by some environmental problem. You may need to open a problem report with IBM Service to get more help tracking this down.