I design a report using BIRT RCP Report Designer (not a Professional).
The report use a Microsoft SQL Server database as a data source so I've downloaded JDBC driver from Microsoft website and made it avialable in report design. Driver class is com.microsoft.sqlserver.jdbc.SQLServerDriver. Preview of the report works fine.
The problem appears when I'm trying to run my report on iServer after deploying it. I get an error:
An exception occurred during processing. Please see the following message for details: Cannot open the connection for the driver: org.eclipse.birt.report.data.oda.jdbc. org.eclipse.birt.report.data.oda.jdbc.JDBCException: Cannot load JDBC Driver class: com.microsoft.sqlserver.jdbc.SQLServerDriver. (Element ID:163)
The BIRT and iServer documentation and forum suggest the only instruction:
The iServer installation process installs and configures DataDirect Connect for ODBC drivers and JDBC drivers. You can also use third-party drivers to connect to data sources, but you must license, install, and configure them. To connect BIRT reports to other JDBC data sources, place the .jar files for the custom database driver in: AC_SERVER_HOME\iServer\Jar\birt\platform\plugins \org.eclipse.birt.report.data.oda.jdbc<version>\drivers
but that can't help me. I do place JDBC driver jar in different folders and restart iServer but there is no result.
What am I doing wrong?
P.S. I'm using trial version of iServer for Windows.