Informix ODBC connection string - Database locale information mismatch

I am trying to connect to an informix db using ado connection from VB6. I have a connection string set up like below
Driver={IBM INFORMIX 3.82 32 BIT};HOST=xxx.xxx.xxx;Server=cms_net;Service=50000;Protocol=olsoctcp;Database=xxx;uid=xxxx;pwd=xxxx
I am getting "Database local information mismatch" error. Can some one help.
I don't want to use the DSN. Is there a way to specify the db locale in the connection string. I trying using DLOC=xxxx and is not working. Help!
cldssAsked:
Who is Participating?

[Webinar] Streamline your web hosting managementRegister Today

x
 
flutophilusConnect With a Mentor Commented:
Add the db_locale and client_locale parameters to your connection string - for example
client_locale=en_us.819;db_locale=en_us.819;

Host=xyz3;server=xyztcp;service=xyzservice;protocol=olsoctcp;database=myvase;uid=informix;pwd=ewqewew;client_locale=en_us.819;db_locale=en_us.819;
0
 
SriVaddadiCommented:
Place a Ado data control on a form. You would need to add reference from components.

Build the connection string by going through the ADO data control properties without using dsn.
Copy that connection string and use it in your code.
0
All Courses

From novice to tech pro — start learning today.