I have installed Informix v11.70 on my Windows 7 x64 development computer and I am working on some oledb .NET code to connect to the Informix database so I can pull off a contacts list.
I installed the developer version of Informix 11.70 (x86 version) on my Windows 7 x64 dev computer.
Using the OpenAdmin tool, I created a new database called ifxDB1
I then created a Contacts table and populated it with Contacts data.
I made sure that the ifxoldec.dll file was registered on the Windows 7 dev computer.
In my VB.NET code, I set up an oleDBConnection object as
...passing it the following connection string;
Persist Security Info=True;
When I try to make a connection to the server, I get the "Error -23197 Database locale information mismatch"
When I created the "Test" database in the rootdbs Dbspaceof the ifxDB1 server instance, I set the db locale to "en_US.CP1252. When I look at the database using the OpenAdmin tool -->Schema Manager, in the Information and Task Status box, it displays Locale as being set to "en_US.1252", not "en_US.CP1252"
If I look at the Information and Task Status box for each of the 4 existing system databases, (sysadmin, sysmaster, sysuser and sysutils), the Locale field is set to "en_US.819"
According to what I have read so far, the DB_Server value in the connection string needs to be set to the locale of the database, in my case, en_US.CP1252.‹ I also set the DB_Server environment variable on the Windows 7 workstation to en_US.CP1252.
I am getting the Database locale information mismatch error when I try to open the connection.
The .NET application is running on the Windows 7 dev computer, along with the Informix 11.70
Any ideas? i am at a standstill.
Thanks in advance for any help you can offer.