cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
1613
Views
0
Helpful
1
Replies

CCX Informix locale mismatch error

brunatoledo
Beginner
Beginner

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 DSNWindows DSN

 

The Informix setnet32 connectTest also worked:

 

Setnet32Setnet32

 

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

Graham Old
Rising star
Rising star

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

Graham Old
Rising star
Rising star

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

 

Getting Started

Find answers to your questions by entering keywords or phrases in the Search bar above. New here? Use these resources to familiarize yourself with the community:

Recognize Your Peers