#1 2020-11-17 20:54:44

kolenmi
Member
Registered: 2020-11-17

Informix database

Hello everyone.
In the company we use the informix database.
Do you have instructions on how to connect to informix?
What are the installation steps?
We plan to use "reportserver community" on the pre-installed(debian) bitnami of the virtual machine.
For testing.
Thanks

Offline

#2 2020-11-18 09:00:11

eduardo
Administrator
Registered: 2016-11-01
Website

Re: Informix database

Hi kolenmi,

Informix is supported directly by ReportServer, so you can install the drivers and it should work out-of-the-box.

https://reportserver.net/en/guides/admi … tasources/

You can put your drivers either in the internal lib directory, or in your external directory if you installed one previously: https://reportserver.net/en/guides/conf … Configdir/

Regards,
Eduardo

Offline

#3 2020-11-18 10:06:49

kolenmi
Member
Registered: 2020-11-17

Re: Informix database

Thank you.
After install driver I get following message:
Could not open connection to: jdbc:informix-sqli://192.168.XX.XXX:1526/namedatabase:informixserver=database_server with user: informix. java.sql.SQLException: Database locale information mismatch.
I tried also Dbschema, and I have same message.
When I enter DB_LOCALE=cs_cz.cp1250 , then I have message "Locale not supported".

Offline

#4 2020-11-24 09:03:19

eduardo
Administrator
Registered: 2016-11-01
Website

Re: Informix database

Hi kolenmi,

we have tried with this: jdbc:informix-sqli://IP:9092/DBNAME:informixserver=INSTANCENAME

and it worked. We did not get the error you are getting. It seems a driver-specific error, have you checked your driver's documentation?

Regards,
Eduardo

Offline

#5 2020-11-24 09:05:27

eduardo
Administrator
Registered: 2016-11-01
Website

Re: Informix database

Hi kolenmi,

I found this: https://serverfault.com/questions/20521 … n-mismatch

maybe this will work:

As per comment responses #5 and #11 by Guy Bowerman at his blog

...you'll need to set it in your environment prior to executing the oninit command to start the server (on UNIX). If the server is on Windows, you can also set the variable in the registry under: HKEY_LOCAL_MACHINE\Software\Informix\Online\%INFORMIXSERVER%\Environment

The fix is to change both CLIENT_LOCALE from the default "EN_US.CP1252" and DB_LOCALE from the default "EN_US.8859-1" to "EN_US.UTF8" in the registry.

Regards,
Eduardo

Offline

Board footer

Powered by FluxBB