stefanm

I think the URL is wrong. Try to add the Service Name. And ve u tried to connect via the SQL Explorer to ur Database with these Settings? Open the proenv and try the to connect via the SQL Explorer with the command line ot get sure that u ve the right driver and the right URL. Do you have an Openedge 10.X Database? Otherwise u need other jar files for the Progress 9.1 Driver.

Hello JasperForge Community, i created the following Jasper Schema and MDX Query with Jasper Workbench. When i test them in the Work Bench there is no Problem. Now i ve tried to put them on Jasper Server. I created the OLAP Connection with no Problem but when i try to enter the MDX Query Jasper Server says Invalid MDX Query. I hope u ve any Ideas...

I found the solution. I took the wrong/not all .jar Files that are needed. If anyone have the same problem with OpenEdge 10.1C you need the following files: dlc/java/pool.jar dlc/java/spy.jar dlc/java/openedge.jar dlc/java/util.jar dlc/java/base.jar In Progressversions < 10.1C you need only progress.jar and jdbc.jar. Greets, Stefan

Hi there, i downloaded yesterday the Jaspersoft Enterprise Edition 3.7 Trial. So far so good, Jasper Server is runnig well on my localhost. What i am trying now is adding a OpenEdge 10 Progress Database as Datasource via JDBC Driver. I ve made the following steps and hope u can tell me where i did a mistake or why it doesnt work: 1. I put the openedge 10.1 JDBC Driver(openedge.jar) in the jasperserver-pro-3.7apache-tomcatwebappsjasperserver-proWEB-INFlib Directory. 2. I restarted my Tomcat Server 3. I logged into JasperServer as Superuser and created a new Folder in the Repository. 4. I tried to add a new Datasource and entered the following values: Driver: com.ddtek.jdbc.openedge.OpenEdgeDriver URL: jdbc:datadirect:openedge://localhost:-1;databaseName=hhhkr;serviceName=hkrolap 5. When i click on Connection Test i get the following exceptions(Code section) The Progress database is running properly, i get an access through SQL Explorer. Iam sure i did something wrong with the JDBC Driver i hope you can give me a Tip Greets from Germany, Stefan P.S.: Please excuse my bad english, school is over a long time ago ;-) Code: Post Edited by stefanm at 07/28/2010 08:11