I got exception: Character to numeric conversion error When I insert into MONEY column: insert into _money_test (amt) values ('123.45') Once you've set the environment variables, don't forget to restart your computer so that they'll be applied when you go to try connecting.I have problem with JDBC application that uses MONEY data type. These last two should help the rest of the Informix tools in the installation folder start working properly if you wanted to try using them. LD_LIBRARY_PATH = \lib \lib\cli \lib\esql It needs to be near the beginning of the list. The PATH variable needs to contain a link to your local Informix driver installation folder (c:\informix, for example). Setting your environment variables properly helps too. Both needed to be set to en_us.57372, which as I understand it, is what tells Informix to use UTF8 encoding. I can't speak to your set up, but I had to change my code to use the client_locale and db_locale variables. If they're not set correctly then it will probably fail. Informix gets really cranky when it comes to the locales. You could also look at the Informix manuals on the IBM Informix Information Center 12.10 web site. But having more detailed information about the error than 'unknown system error' may help you. Have you checked the SETNET32 setting? Have you checked the OBDC connection configuration? I believe SSRS is a Windows-based system, and I'm by no means a Windows expert, so there's a limit to what I can do to point you in the right direction. That's the easy part the hard part is knowing what you need to set. In particular, locale categories are stored in $INFORMIXDIR/gls. That's probably clear as mud, but 'unable to load locale categories' probably means that $INFORMIXDIR, which defaults to /usr/informix on Unix-like systems (and something like C:\Informix on Windows systems IIRC) is either not set correctly or is pointing somewhere invalid. Territory) and mod (locale modifier) are from the CLIENT_LOCALE andĬodeset is from the database locale (from the DB_LOCALE, if it is set, They are compatible if a valid locale exists on the serverĬomputer with the name where lg_tr (language and Server connection, check that the client and database locales areĬompatible. If a client application receives this error when it requests a database Also check if INFORMIXDIR points toĪ valid directory where IBM Informix products are installed. The "SET NO COLLATION" statement, check that the session's default The "SET COLLATION" statement, check that the value passed to the The environment variable specifying the locale category has a wrongĬheck the value of the corresponding environment variable,ĬLIENT_LOCALE or DB_LOCALE. When I use an Informix command finderr, I get the output shown: $ finderr -23101Īn invalid locale name was supplied for the locale initialization.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |