Informix Locale Issue

mlovern · #1 (**permalink**) 03-12-04, 09:40

I can connect to informix successfully with an older informix driver, but as soon as I put in their newest driver I get the following message.

Code sets of the locale categories are not the same.

Any help would be aprreciated

mlovern · #2 (**permalink**) 03-12-04, 09:44

[QUOTE]Originally posted by mlovern
I can connect to informix successfully with an older informix driver, but as soon as I put in their newest driver I get the following message.

Code sets of the locale categories are not the same.

Any help would be aprreciated [/QUOTE

Sorry, it's jdbc not odbc.]

Amit Dandekar · #3 (**permalink**) 03-12-04, 10:15

can you please provide more details ?
I should be able to help you out.

1) Which version of JDBC you were using and what version you changed to ?
2) are you setting DB_LOCALE and CLIENT_LOCALE
properties in your connection url ?

3) What is the locale of the database you are connecting to?
( use dbaccess , select database -> info - > NLS )

4) are you trying to connect to the db from windows box or unix box ?

mlovern · #4 (**permalink**) 03-12-04, 10:28

Quote:

Originally posted by Amit Dandekar
can you please provide more details ?
I should be able to help you out.

1) Which version of JDBC you were using and what version you changed to ?
2) are you setting DB_LOCALE and CLIENT_LOCALE
properties in your connection url ?

3) What is the locale of the database you are connecting to?
( use dbaccess , select database -> info - > NLS )

4) are you trying to connect to the db from windows box or unix box ?

1. Informix JDBC Driver 2.21.JC5
2. I have tried to
3. en_US.8859-1
4. Windows 2000

Internet Services

Web Development

Digital Marketing

Consumer Tech