cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
Announcements

Community Helping Community

437
Views
0
Helpful
1
Replies
Highlighted
Beginner

CCX Informix locale mismatch error

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:

 

odbc ok.PNGWindows DSN

 

The Informix setnet32 connectTest also worked:

 

setnet ok.PNGSetnet32

 

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!

1 ACCEPTED SOLUTION

Accepted Solutions
Rising star

Re: CCX Informix locale mismatch error

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

 

View solution in original post

1 REPLY 1
Rising star

Re: CCX Informix locale mismatch error

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

 

View solution in original post

CreatePlease to create content
Content for Community-Ad
FusionCharts will render here