Just installed WebFOCUS Reporting Server 76 on Windows XP with Mysql 5.1. When I run the test I get: Connecting to the distribution server - fail. Everything work except Report Caster.

I think the problem has to do with the JDBC driver not added correctly.

Could somebody advice me on how to solve this issue. Best regards, Stellan

This message has been edited. Last edited by: Kerry,

Invariably, whenever I install the products on a clean machine, there is one thing the install process does not do. And that is to add the path to the java jre or sdk. I always have to put in 'C:\Program Files\Java\jdk1.6.0_03\jre\bin\server;' (or equivalent) and then reboot the system to make the connection to the distribuition server work.

Thanks. But could you please elaborate with me more.

In what places do you need to set the java classpath?

This is what I get when trying to start the distribution server.

ReportCaster cannot communicate with the ReportCaster Repository. Check that the Application Server is properly configured with the correct JDBC driver.

- The file in C:\ibi\ReportCaster76\bin\classpath?

I also dont understand where to put the JDBC driver? I downloaded mysql-connector-java-5.1.8-bin.jar and placed the file in C:\ibi\ReportCaster76\bin.

This is how the classpath file in C:\ibi\ReportCaster76\bin

set CMD_LINE_ARGS=
rem set CMD_LINE_ARGS=MASTER -f
rem set CMD_LINE_ARGS=FAILOVER
set DSINSTALL=C:\ibi\ReportCaster76
set DSINSTALL_PROD=C:\ibi\ReportCaster76
set DSHOST=infobuild
set DSPORT=8200
set CLASSPATH=C:\Program\Java\jr6\bin\mysql-connector-java-5.1.8-bin.jar

BR, Stellan

The path to the jre or sdk java stuff should be set in the system variables of your computer.
The path to the jdbc for mysql should be set in the report caster environment, you should have given the path to the driver when installing the report caster. If you did not, you can add it later using the edit option for report caster from the start menu, or the editit.bat in the report caster bin directory.

Sounds like you need to look through the Install manual. Especially Chapter 8 - ReportCaster Post-Installation Tasks and Appendix C - additional ReportCaster Repository Topics and Tasks

If you are running ReportCaster as a Service then you will also need to use regedit to change/correct the classpath in the registry. Also if you had Tomcat preinstalled or didn't supply the installer with the correct path to the JDBC driver then you will have to add the JDBC driver to Tomcat's classpath too.

All of this is covered in the Install Manual.

Cheers

Stu

There are a lot of documents on techsupport.ibi.com that talk about how to change/check the JDBC jars fro ReportCaster.

While the following document specifically references SQL Server, the locations for setting the classpath are the same. As a result as long as you are entering/verifying the MySQL information, it should work for you:

http://techsupport.information...om/sps/51242524.html

[SOLVED] Thanks everybody! The problem is solved.