You are not logged in.
Pages: 1
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
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
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
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
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
Pages: 1