08-25-2011 05:52 PM - edited 03-13-2019 07:30 PM
Hi guys,
I'm trying to setup a JDBC connection to the UCCX db_cra database using the uccxhruser. I'm trying the JDBC URL:
jdbc:jtds:sybase://uccxhostname:1504/uccxhostname_uccx
But can't seem to connect. I think I have the DB name bit wrong. Anyone else setup a connection that can advise what they used?
Cheers,
Nathan
Solved! Go to Solution.
08-29-2011 04:53 AM
Hi
It's Informix... assuming you have the informix JDBC drivers set up:
jdbc:informix-sqli://uccxhostname:1504/db_cra:INFORMIXSERVER=uccxhostname_uccx
Regards
Aaron
Please rate helpful posts..
08-28-2011 08:48 PM
08-28-2011 09:20 PM
Hi Shalu,
Thanks for that but I'm trying to connect to the UCCX sybase historical reporting database not an external SQL server as per that post. Do you have what the connection URL should look like for this?
Cheers,
Nathan
08-29-2011 04:53 AM
Hi
It's Informix... assuming you have the informix JDBC drivers set up:
jdbc:informix-sqli://uccxhostname:1504/db_cra:INFORMIXSERVER=uccxhostname_uccx
Regards
Aaron
Please rate helpful posts..
08-29-2011 05:28 AM
Ahhh right. Wrong type. That worked a treat thanks for that!
03-28-2012 09:15 AM
Hi,
I've tried to connect to the Historical DB of UCCX 8.5, but I'm getting an exception "No connect permission" if I try to login with the os admin.
Caused by: java.sql.SQLException: No connect permission. at com.informix.jdbc.IfxSqli.a(IfxSqli.java:3609) at com.informix.jdbc.IfxSqli.E(IfxSqli.java:3934)
If I use a normal Administrator account, I get an "Incorrect password or username" exception:
Caused by: java.sql.SQLException: Incorrect password or user com.informix.asf.IfxASFRemoteException: username is not known on the database server. at com.informix.jdbc.IfxSqliConnect.(IfxSqliConnect.java:1205)
Which user could be used to connect to the database?
03-28-2012 09:24 AM
Hi,
In regards to the historical user queries in 8.x the user ID is "uccxhruser" and the password of this user can be changed through UCCX administrator - tools - paswword managent page.
Section "Creating a System DSN for Wallboard" also provides some pointers on how to create a DSN connection to UCCX database
Hope this helps.
Anand
Please rate helpful posts..
03-28-2012 10:09 AM
Yessss, working!
Thanks Anand for you quick reply!
03-28-2012 07:30 PM
Hi Paul,
Glad to know that its working :-).
Please don't forget to rate the helpful posts, by clicking on the stars below the right answers.
Thanks,
Anand
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