vBulletin Search Engine Optimization
| |||||||
| Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
| ||||
| Hi Markus, This error is because conversion error of this particular Euro symbol from Unicode(as IBM Informix ODBC Driver will get Unicode data from Application) to DB Locale. Based on the information you provided this particular symbol doesn't seem to be present in the current GLS kit (code pages) hence this comes out as conversion error ( i.e -21005, error message is not accurate ). Now, there could be two possibilities, first either the Euro Symbol which you are using doesn't seem to be supported between Unicode (i.e in this case UCS2 ) and DB locale (i.e DE_de.819 ) or secondly there is bug in IBM Informix ODBC/GLS. I would say contact your Tech Support and log a bug. Thanks & Regards -Shesh "MBruns" <markus.bruns@telekom.de> Sent by: informix-list-bounces@iiug.org 06/06/2006 05:15 PM To informix-list@iiug.org cc Subject Error -21005 inserting Euro symbol via ODBC driver 2.90 TC4 Hello, I have the folllowing problem: I want to insert the Euro Symbol in a character field in a Informix 10.00.FC4 database. With sqlcmd on Unix, there is no problem. But, if I try to insert the Euro symbol from am Windows XP System via ODBC or Informix.NET driver, I get the error message: -21005 unspecified system error. Client Environment: Windows XP Informix SDK 2.90 TC4 Client_Locale=de_DE.CP1252 (Setnet32) DSN Properties: Client Locale = de_DE.819 Database Locale = de_DE.819 Server Environment SUN UNIX Informix DS Version 10.00.FC4 Database Locale = de_DE.819 I hopy anyone can help me. Greetings _______________________________________________ Informix-list mailing list Informix-list@iiug.org http://www.iiug.org/mailman/listinfo/informix-list |