Oninit cdi / Archive
Talk to an expert →

Unspecified System Error = -21005. (State:S1000, Native Code: 520D)

Posted in 2008

Topics: Connectivity: ODBC / JDBC / .NET

eferreyra — — source: Usenet: comp.databases.informix

Hi i get this error: Unspecified System Error = -21005. (State:S1000, Native Code: 520D) on this query: SELECT ADJ_COD, ADJ_SOL_COD, ADJ_PRY_COD, ADJ_FAS_COD, ADJ_ENT_COD, ADJ_TAR_COD, ADJ_NOM, ADJ_FUL_QUA_NAM FROM adjuntos WHERE Upper(adj_ful_qua_nam) = "\\\\IMAGE\\TPROJECTDOC\\1034\\PRY466\\FAS3\\TAR1\\DRS-S1034-P466-1-NUMERO DE ESTABLECIMIENTO - PROVINCIA DE MENDOZA.DOC" Using ODBC (2.90 TC6 and 3.00 TC2DE) against this IDSs: IBM Informix Dynamic Server Version 9.40.UC8 IBM Informix Dynamic Server Version 10.0.FC6

↪ replying to eferreyra
Fernando Nunes — — source: Usenet: comp.databases.informix

eferreyra wrote: > Hi i get this error: > > Unspecified System Error = -21005. (State:S1000, Native Code: 520D) > > on this query: > > SELECT ADJ_COD, ADJ_SOL_COD, ADJ_PRY_COD, ADJ_FAS_COD, ADJ_ENT_COD, > ADJ_TAR_COD, ADJ_NOM, ADJ_FUL_QUA_NAM > FROM adjuntos WHERE Upper(adj_ful_qua_nam) = "\\\\IMAGE\\TPROJECTDOC> \\1034\\PRY466\\FAS3\\TAR1\\DRS-S1034-P466-1-NUMERO DE ESTABLECIMIENTO - > PROVINCIA DE MENDOZA.DOC" > > Using ODBC (2.90 TC6 and 3.00 TC2DE) against this IDSs: > > IBM Informix Dynamic Server Version 9.40.UC8 > IBM Informix Dynamic Server Version 10.0.FC6 > > > From XP Professional Machines > > Connection has database and client locale set to "en_US.819" which is > the same of the connection database. > > Some idea ??? > One: http://www.webservertalk.com/archive221-2007-7-1940429.html http://groups.google.co.uk/group/comp.databases.informix/browse_thread/thread/7c47fdbca1abc7a7/4afcc73b402367ca Regards.

↪ replying to eferreyra
Sheshnarayan Agrawal — — source: Usenet: comp.databases.informix

-21005 says "Lossy conversion during translation" ... I didn't find though this error number listed in "finderr" utility !! As the message explains, it seems one of the chars in your data, which gets converted from CLIENT Locale to DB Locale and vice versa is not right. Beside from CSDK 2.70 onwards there is Unicode implementation in ODBC Driver which will have conversion taking place from Unicode(Only UCS-2 on Windows) to DB locale and vice versa and possibly one of the chars is not accepted in these code sets (i.e UCS-2 and DB locale). -Shesh eferreyra <eferreyra@gmail.com> Sent by: informix-list-bounces@iiug.org 22/01/2008 21:46 To informix-list@iiug.org cc Subject Unspecified System Error = -21005. (State:S1000, Native Code: 520D) Hi i get this error: Unspecified System Error = -21005. (State:S1000, Native Code: 520D) on this query: SELECT ADJ_COD, ADJ_SOL_COD, ADJ_PRY_COD, ADJ_FAS_COD, ADJ_ENT_COD, ADJ_TAR_COD, ADJ_NOM, ADJ_FUL_QUA_NAM FROM adjuntos WHERE Upper(adj_ful_qua_nam) = "\\\\IMAGE\\TPROJECTDOC\\1034\\PRY466\\FAS3\\TAR1\\DRS-S1034-P466-1-NUMERO DE ESTABLECIMIENTO - PROVINCIA DE MENDOZA.DOC" Using ODBC (2.90 TC6 and 3.00 TC2DE) against this IDSs: IBM Informix Dynamic Server Version 9.40.UC8 IBM Informix Dynamic Server Version 10.0.FC6 >From XP Professional Machines Connection has database and client locale set to "en_US.819" which is the same of the connection database. Some idea ??? _______________________________________________ Informix-list mailing list Informix-list@iiug.org http://www.iiug.org/mailman/listinfo/informix-list

Related threads