Re: connecting to Informix 11.5 from .NET error

looking the directory structure of Data Sever 9.5 for linux package , have the directory locale with cs_CZ.iso88592 and cs_CZ.utf8 . I never worked with DRDA in production only for tests and without setting the locale , but I already experience a problem in the CSDK for windows where the directory locale are installed with wrong name (pt_pr != pt_BR), then I just renamed manually and works... Take a look in your locale directory... I don't remember if the match of the locales are case sensitive , I believed not. If your environment are just for test, rename the directory to lower case (cs_CZ.iso88592 != cs_cz.iso88592).... You say "Database locale is set to cs_cz.8859-2" .  * cs_cz.8859-2 != cs_CZ.iso88592 . With CSDK I experience a problem with the "iso" word in the locale set . The weird thing , in the IDS database don't exists the codeset "iso88592" for cs_cz , just "8859-2" , and in the DB2 Data Server have only "iso88592" I don't believe the client are smart enough to identify this... nezreli@gmail.com wrote: > On 11 velj, 16:35, Cesar Inacio Martins > <cesar_inacio_mart...@yahoo.com.br> wrote: >> Probably you isn't setting correctly your CLIENT_LOCALE on the client program or the value used there don't exists in a convert file. >> >> >> Check what the value of your CLIENT_LOCALE , if is unset, try set to "unicode" . >> > > Thanks for your detailed answer but I cannot apply it to my case. I'm > using Informix driver which comes with DB2 9.5 package. This driver > uses DRDA protocol. As far as I know, this driver cannot accept > CLIENT_LOCALE as a parameter and package doesn't come with setnet32 > utility. As far as I know there is no way to specify what is my > client_locale with this particular driver. CSDK 3.50 driver doesn't > have this problem since I can set CLIENT_LOCALE either with setnet32 > or directly in my connection string. Unfortunately, driver has other > problems that renders him unusable. Veja quais são os assuntos do momento no Yahoo! +Buscados http://br.maisbuscados.yahoo.com

On Feb 11, 8:48 pm, Cesar Inacio Martins <cesar_inacio_mart...@yahoo.com.br> wrote: > looking the directory structure of Data Sever 9.5 for linux package , have the > directory locale with cs_CZ.iso88592 and cs_CZ.utf8 . > > I never worked with DRDA in production only for tests and without setting the locale , but I already experience a problem in the CSDK for windows where the directory locale are installed with wrong name (pt_pr != pt_BR), then I just renamed manually and works... > > Take a look in your locale directory... > I don't remember if the match of the locales are case sensitive , I believed not. If your environment are just for test, rename the directory to lower case (cs_CZ.iso88592 != cs_cz.iso88592).... > > You say "Database locale is set to cs_cz.8859-2" . >  * cs_cz.8859-2 != cs_CZ.iso88592 . > With CSDK I experience a problem with the "iso" word in the locale set . > > The weird thing , in the IDS database don't exists the codeset "iso88592" for cs_cz , just "8859-2" , and in the DB2 Data Server have only "iso88592" > I don't believe the client are smart enough to identify this... Hi. On the server side everything looks fine. I have $INFORMIXDIR/gls/lc11/ cs_cz/ folder with files 0390.loc (8859-2) and 04e2.loc (cp1250). In the cv9 folder there are conversion files for these codepages. Enviroment variables on the server are set: CLIENT_LOCALE=cs_cz.1250 DB_LOCALE=cs_cz.8859-2 On the client side, DB2 9.5 is installed on a location: C:\\Program Files\\IBM\\SQLLIB I have checked entire folder and subfolders. There is no mention of any kind of files like those on the server. There is no gls folder or locale folder. Only thing that resembles conversion files are located in the folder C:\\Program Files\\IBM\\SQLLIB\\conv\\alt\\. In there there are about 20 cnv files ie 04370923.cnv, 08500923.cnv...