dbTalk Databases Forums  

ODBC Error

comp.databases.informix comp.databases.informix


Discuss ODBC Error in the comp.databases.informix forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
laurin1
 
Posts: n/a

Default ODBC Error - 06-21-2007 , 06:28 PM






Does anyone know what the the Unspecified System Error = -21000
(#21000) means?


Reply With Quote
  #2  
Old   
Sheshnarayan Agrawal
 
Posts: n/a

Default Re: ODBC Error - 06-22-2007 , 12:36 AM






-21000 error reads as follows ..

Invalid byte in codeset conversion input.

Code-set conversion cannot recognize data that is being passed between the
server and the client. Check DB_LOCALE and CLIENT_LOCALE settings in your
initialization file or your environment.

You will get this error because your data (may be one of the chars/bytes)
doesn't have mapping (i.e. conversion allowed) from your DB locale to
client locale or vice versa. In the similar line you might also get
-21001, -21002, -21003 or -21004.

-Shesh




laurin1 <keithdavis (AT) solidtechservice (DOT) com>
Sent by: informix-list-bounces (AT) iiug (DOT) org
22/06/2007 04:58

To
informix-list (AT) iiug (DOT) org
cc

Subject
ODBC Error






Does anyone know what the the Unspecified System Error = -21000
(#21000) means?

_______________________________________________
Informix-list mailing list
Informix-list (AT) iiug (DOT) org
http://www.iiug.org/mailman/listinfo/informix-list



Reply With Quote
  #3  
Old   
Sheshnarayan Agrawal
 
Posts: n/a

Default RE: ODBC Error - 06-22-2007 , 10:50 AM



Sending to informix list for the awareness of solution ...

-Shesh




"Keith Davis" <keithdavis (AT) pridedallas (DOT) com>
22/06/2007 20:43

To
Sheshnarayan Agrawal/India/IBM@IBMIN
cc

Subject
RE: ODBC Error






Thanks. That helped me find the problem. It was a bad character.

Keith Davis (214) 906-5183


From: Sheshnarayan Agrawal [mailto:shagrawal (AT) in (DOT) ibm.com]
Sent: Friday, June 22, 2007 12:37 AM
To: laurin1
Cc: informix-list (AT) iiug (DOT) org; informix-list-bounces (AT) iiug (DOT) org
Subject: Re: ODBC Error


-21000 error reads as follows ..

Invalid byte in codeset conversion input.

Code-set conversion cannot recognize data that is being passed between the
server and the client. Check DB_LOCALE and CLIENT_LOCALE settings in your
initialization file or your environment.

You will get this error because your data (may be one of the chars/bytes)
doesn't have mapping (i.e. conversion allowed) from your DB locale to
client locale or vice versa. In the similar line you might also get
-21001, -21002, -21003 or -21004.

-Shesh



laurin1 <keithdavis (AT) solidtechservice (DOT) com>
Sent by: informix-list-bounces (AT) iiug (DOT) org
22/06/2007 04:58


To
informix-list (AT) iiug (DOT) org
cc

Subject
ODBC Error








Does anyone know what the the Unspecified System Error = -21000
(#21000) means?

_______________________________________________
Informix-list mailing list
Informix-list (AT) iiug (DOT) org
http://www.iiug.org/mailman/listinfo/informix-list



Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.