I migrate from Informix 7 to IDS 11.10.0000 FC2.
When i try to insert o show (old data) with characters special,
example €,italian caracters, we receive a run time error:
Run time error '40002':
S100:InformixInformix ODBC DriverUnspecified System Error =
We store data in diferents languages Spanish, Portuguese,
English,Italian, German and French.
ODBC : IBM Informix ODBC Driver Setup Utility 3.00.0000 3.00.TC3
SERVER : AIX 5
IDS :11.10.0000 FC2.
Clients :Windows XP access to server using ODBC ->DSN
What i need to do?
Any help will be aprecciated.
NOTICE: developerWorks Community will be offline May 29-30, 2015 while we upgrade to the latest version of IBM Connections. For more information, read our upgrade FAQ.
This topic has been locked.
1 reply Latest Post - 2010-07-19T12:16:32Z by luis_ventura
Pinned topic Problem with EURO € Simbol in IDS 11.10.0000 FC2.
Answered question This question has been answered.
Unanswered question This question has not been answered yet.
Updated on 2010-07-19T12:16:32Z at 2010-07-19T12:16:32Z by luis_ventura
luis_ventura 2700012E281 PostACCEPTED ANSWER
Re: Problem with EURO € Simbol in IDS 11.10.0000 FC2.2010-07-19T12:16:32Z in response to SystemAdminHello Abelardo:
I suffered a similar problem with € symbol.
We changed the Connect Version in our clients, and the € symbol started to cause the -21005 error. As far as I know, the problem is not on the server side, but on the client Side (or at least, in the character conversion between server locale and client locale). Open a session from the client and execute a onstat -g env for this session. You should search for the DB_LOCALE, CLIENT_LOCALE and SERVER_LOCALE and post them here. Maybe this would help us to get a solution.