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

[eferreyra]

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 ???

[Fernando Nunes]

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.

[Sheshnarayan Agrawal]

-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 <efer...@gmail.com> Sent by: informix-l...@iiug.org 22/01/2008 21:46

To inform...@iiug.org cc Subject

_______________________________________________
Informix-list mailing list
Inform...@iiug.org
http://www.iiug.org/mailman/listinfo/informix-list