10-22-2013 08:41 AM - edited 03-14-2019 12:37 PM
We are attempting to connect Jaspersoft reporting to UCCX (vers. 8.5.1) informix database for read all access. We have set the uccxhruser password, installed the informix JDBC drivers into jaspersoft application and are using the following connection:
jdbc:informix-sqli://<IP>:1504/db_cra:INFORMIXSERVER= <hostname>
We are getting the following error:
Is there anything obvious in the setup, any help is appreciated.
10-22-2013 08:46 AM
Your particular database name should be "uccx_publisher_uccx".
One should note however, be careful in how often you query the database as it can have an impact on system stability and performance.
Tanner Ezell
www.ctilogic.com
10-22-2013 08:48 AM
Your particular database name should be "uccx_publisher_uccx".
One should note however, be careful in how often you query the database as it can have an impact on system stability and performance.
Tanner Ezell
www.ctilogic.com
10-22-2013 08:55 AM
Yes, thanks for the help. In fact we did have an underscore where required, I inadvertently posted an original error message. The latest attempt with the proper syntax: uccx_publisher_uccx gave the same error.
Regards,
10-22-2013 08:59 AM
Reformat your connection string as such:
jdbc:informix-sqli://
Tanner Ezell
www.ctilogic.com
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