Hi, I am using Jasper report server Product Version: 4.2.1. I am trying to connect sqlite database from jasperserver via ODBC. I use the JDBC:ODBC bridge in Ireport to develop the report and can run successfully. Now I want to deploy it to Jasper server and I need data connection. I have tried using JNDI connection and also JDBC connection but both doesn't work for me. Test connection keep fail and I don't know what is the problem. I use this class and URL to connect: classname: sun.jdbc.odbc.JdbcOdbcDriver url: jdbc:odbc: I check log file but no useful information regarding the fail connection. I also placed "sqlite-jdbc-3.7.2.jar" and "sqljdbc4.jar" in "..webappsjasperserverWEB-INFlib". Please someone guide and give me some clue :(
