I build a report in ireport's with a connection to a Informix database. It uses a JDBC connection with ifxdriver, and it work's perfectly.
The problem is when it was publish in the jasperserver. It always give the error "An error occurred while creating the connection. Try again."
The datasource is perfectly working, giving connection passed.
I tried several solution without success, i Test the driver with a jsp page (Works), disabling firewall, building a test report, and so many other.
Any way i can debug the problem? or any special feature for connection informix server?
Please take a look at jaserver.log file to see what kind of error you are getting - connection refused, timed out, user credential error, driver error, etc. This could help to determine the root cause of the problem.
post a snapshot of ur data which ur entering to publish..
i posted the xml, but already tried with a simple query!
did you add the connection to jasperserver too?
The problem is creating a connection connection.
An error occurred while creating the connection. Try again.
I got the same error, did you solve it?