UCCX 8.5.1 Informix uccxhruser access

[Chris Nordin]

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.

[tannerezell]

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

[Tanner Ezell]

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

[Chris Nordin]

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,

[Tanner Ezell]

Reformat your connection string as such:

jdbc:informix-sqli://:1504/db_cra:INFORMIXSERVER=

Tanner Ezell
www.ctilogic.com