.NET Provider X Decimal Point

Posted in 2010

Topics: Connectivity: ODBC / JDBC / .NET, Platform-Specific Issues

André Luiz Rufino — Fri, 17 Sep 2010 18:55:24 — source: IIUG Forums & Mailing Lists

Hi folks, Little trouble with .NET infomix provider and portuguese aplication servers. In one of ours servers, we have windows server 2003 with .NET aplication tha points to a ODBC drivers. In ODBC sets, we have DBMONEY set to "," and everything goes fine. But other aplication using the same windows server and don't use ODBC driver but ifmx provider for .NET Well, we can't send the decimal point like COMMA. It always goes like DOT. In brasilian monetary system it doesn't make sense. Does anybody here tryied to do this with .NET provider? Is there a way to send in connection string, the value of DBMONEY set to "," ? thanks s lot André Luiz Rufino

↪ replying to André Luiz Rufino

Alexandre Marini — Fri, 17 Sep 2010 18:59:24 — source: IIUG Forums & Mailing Lists

Hi André. We have some excelent brazilian articles regarding nls convertions, codepages etc on our friend Cesar blog: http://www.imartins.com.br/informix/ There´s a section "para desenvolvedores", check it out ok? Best regards. Obs: on purpose, had you already made your registration on BRIUG site??? Check it out, then!!! It´s growing up already. Em 17/09/2010 14:55, André Luiz Rufino escreveu: > Hi folks, > > Little trouble with .NET infomix provider and portuguese aplication servers. > In one of ours servers, we have windows server 2003 with .NET aplication tha > points to a ODBC drivers. In ODBC sets, we have DBMONEY set to "," and > everything goes fine. But other aplication using the same windows server and > don't use ODBC driver but ifmx provider for .NET > > Well, we can't send the decimal point like COMMA. It always goes like DOT. In > brasilian monetary system it doesn't make sense. Does anybody here tryied to > do this with .NET provider? Is there a way to send in connection string, the > value of DBMONEY set to "," ? > > thanks s lot > > André Luiz Rufino > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > -- Alexandre Marini Tecnologia da Informação - DBA msn: alexandre_marini@hotmail.com SEFAZ-MS / SGI-UGSR / Sistemas IBM-Informix Cert-Info-Mgmt_color <Cert-Info-Mgmt_color.jpg> IBM Informix Dynamic Server Certified Professional V10 / V11

↪ replying to André Luiz Rufino

Cesar Inacio Martins — Fri, 17 Sep 2010 19:40:14 — source: IIUG Forums & Mailing Lists

Hi Andre, As far I know, specify the DBMONEY into the connection string, is not possible... You can use DBMONEY variable/setnet32 or CLIENT_LOCALE (variable/setnet32/connectionstring). Search into the Information Center for ".net dbmoney" and check the first page returned. --- Em sex, 17/9/10, André Luiz Rufino <andre_rufino@msn.com> escreveu: De: André Luiz Rufino <andre_rufino@msn.com> Assunto: .NET Provider X Decimal Point [21341] Para: ids@iiug.org Data: Sexta-feira, 17 de Setembro de 2010, 15:55 Hi folks, Little trouble with .NET infomix provider and portuguese aplication servers. In one of ours servers, we have windows server 2003 with .NET aplication tha points to a ODBC drivers. In ODBC sets, we have DBMONEY set to "," and everything goes fine. But other aplication using the same windows server and don't use ODBC driver but ifmx provider for .NET Well, we can't send the decimal point like COMMA. It always goes like DOT. In brasilian monetary system it doesn't make sense. Does anybody here tryied to do this with .NET provider? Is there a way to send in connection string, the value of DBMONEY set to "," ? thanks s lot André Luiz Rufino ******************************************************************************* Forum Note: Use "Reply" to post a response in the discussion forum.