Results 1 to 2 of 2
  1. #1
    Join Date
    Jan 2012
    Posts
    2

    Unanswered: Informix SDK Client 4.10 decimal fields error

    I'm using "Informix Client SDK 4.10" to make an application in Visual Studio 2010 asp.net vb.net.
    To query the database I use the following code:

    Code:
    Dim ds As New DataSet()
    Dim str_sql As String = ""
    str_sql = "select * from prova order by id"
    Dim da As New IfxDataAdapter(str_sql, conn_ifx)
    da.MissingSchemaAction = MissingSchemaAction.[Error]
    da.FillSchema(ds, SchemaType.Source, nome_tabella)
    da.Fill(ds, nome_tabella)
    The code works correctly if in the table there are no decimal type fields.
    but if in the table there are the decimal type fields then I get the following error:

    input string format not valid
    I point out that:
    Client_Locale = en_US.819; DB_LOCALE = en_US.819
    and informix cli is Italian version.
    It may depend on the setting of the culture?

  2. #2
    Join Date
    Sep 2011
    Location
    Pont l'Abbé, Brittany, France
    Posts
    381
    Provided Answers: 1
    Hi

    I would try changing CLIENT_LOCALE to the italian codepage that is compatible with en_us.819
    I would also try playing with the DBMONEY env variable on the client side. Your application probably uses the , character as a decimal separator, instead of the . which is used by default.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •