CCX Informix locale mismatch error

[brunatoledo]

Hi all!

I'm trying to connect to the CCX Database Informix with a .NET program, but I'm receiving this error when I try to open the connection: [Informix][Informix ODBC Driver][Informix]Database locale information mismatch.

This is my connection string:  "Driver={IBM INFORMIX ODBC DRIVER}; Host=xx.x.x.xx; Server=uccx01_uccx; Service = 1504; Protocol = onsoctcp; Database = db_cra; UID = uccx123; PWD = abc123; ";

I've already created a connection with windows native ODBC application, and it worked:

Windows DSN

The Informix setnet32 connectTest also worked:

Setnet32

On both (windows ODBC and Setnet32), the client_locale and database_locale are set as en_US.57372. 

But at the .NET program the locale mismatch error apears.

Anyone knows how can I solve this?

Thanks!

[Graham Old · Accepted solution]

This is my connection string from .NET, it is setup to work with both Pub and Sub

If ADbActive = True Then
mydb = "Database=db_cra;Host=" + CCXIP + ";Server=" + ADBname + ";"
Else
mydb = "Database=db_cra;Host=" + CCXIPB + ";Server=" + BDBname + ";"
End If

mydb = mydb + "Service=1504;Protocol=onsoctcp"
mydb = mydb + ";UID=uccxhruser;Password=" + HRPassword
mydb = mydb + ";db_locale=en_US.57372"

UID must be uccxhruser and the only other difference I see is I am defining  the locale

Graham