Re: Informix ODBC, Locales and WindowsNT

I am facing a similar problem accessing data in international languages. Server: Informix SE 7.2 on Sun Solaris 2.5.1 The server is setup to use the character set "en_us.utf8" (that makes our DB_LOCALE=en_us.utf8) which supports the multibyte codeset that the various languages (Japanese, Italian, French, etc.) require. Client: Windows-95 on Pentium PC. The client PC is setup for Japanese and the strings that are displayed in the windows environment are displayed in Japanese. ODBC: I am using Openlink 1.5 Type-2 driver. I am using MS-Access to display the data on the client . The data looks like garbage. The data in my database looks good. I telnetted to my UNIX server from the PC setup in Japanese, set "export DB_LOCALE=en_us.utf8" and used "dbaccess" and looked at the data. The data is displayed fine. I didnot set the CLIENT_LOCALE to anything. Infact if I set the CLIENT_LOCALE="ja_jp.sjis" or something similar while using "dbaccess" the data looks like garbage. I was reading the GLS documentation but I am kind of stuck at this point. My question is what variables, if any, are to be set for any client, say MS-ACCESS, would be able to display this multibyte character data properly. Do I have run SetNet32 to setup the DB_LOCALE and CLIENT_LOCALE on the Client PC (Windows 95 registry). What is this SetNet32 and where can I find info. about it? Are the latest Openlink drivers or Informix provided drivers resolve this problem? The problem is the same for French and also Italian data. Any help is highly appreciated. Thanks, Suresh. Rok Vizintin wrote: > I had the same problem and I solved it using Intersolve ODBC 3.01 (I couldn't > configure ODBC 2.80). > Before you configure 3.01, install NT SP3 to be sure the right ODBC Data Source > Administrator (ODBC DSA) is installed. The system error 126 tells you than the > ODBC DSA does not find some files, required for Intersolve 3.01. Check in > Control Panel /System/Environment that you have PATH variable properly set to > your Informix/Bin directory and that the INFORMIXDIR variable is set. > > I hope it will help, it did here ! > > Leos Urban wrote: > > > Hello, > > I have problem with Informix ODBC (2.80 Version, supplied with IDS7.30NT). > > I can access databases created with default DB_LOCALE ('EN_US...'), > > but when I want to access czech database (DB_LOCALE=cs_cz.cp1250), > > I got error message: > > State=S1000,Error=-23101, Unable to load locale categories. > > Parameters of ODBC source are set to ClientLocale="cs_cz.cp1250" > > and DbLocale="cs_cz.cp1250" as they are in SetNet32. > > SetNet & DB are set OK, I can work with SQLEditor with czech ordering,.... > > Operating System is WindowsNT 4.0, SP3 with czech regional setting. > > Informix IDS/WE 7.30.TC3 > > Version of ODBC DriverManager is 3.0.28.22 > > Do you have any advice? > > Leos > > > > P.S. I tested Intersolv ODBC 3.01, here was some system error 126 with IIS, > > with MS Excel worked fine.