11-06-2018 08:50 AM - edited 03-14-2019 06:36 PM
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!
Solved! Go to Solution.
11-07-2018 04:06 AM
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
11-07-2018 04:06 AM
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
Discover and save your favorite ideas. Come back to expert answers, step-by-step guides, recent topics, and more.
New here? Get started with these tips. How to use Community New member guide