MSSQL2000 Connectivity issue with BIRT 2_3_0

Amninder

Hi All,<br />
i am a BIRT newbie... i am trying to view a report by placing it in the WebViewer inside runtime2_3_0 folder. i get the following error<br />
<br />
<strong class='bbc'>An exception occurred during processing. Please see the following message for details:<br />
Cannot open the connection for the driver: org.eclipse.birt.report.data.oda.jdbc.</strong><br />
Cannot load JDBC Driver class: com.microsoft.jdbc.sqlserver.SQLServerDriver. <br />
exception.error ( 1 time(s) )<br />
detail : org.eclipse.birt.report.engine.api.EngineException: 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.Cannot load JDBC Driver class: com.microsoft.jdbc.sqlserver.SQLServerDriver. at org.eclipse.birt.report.engine.executor.ExecutionContext.addException(ExecutionContext.java:1107) at org.eclipse.birt.report.engine.executor.ExecutionContext.addException(ExecutionContext.java:1071) at org.eclipse.birt.report.engine.executor.QueryItemExecutor.executeQuery(QueryItemExecutor.java:88) at org.eclipse.birt.report.engine.executor.TableItemExecutor.execute(TableItemExecutor.java:62) at <br />
<br />
<br />
i have included 3 jars reuired for MSSQL (msbase.jar,mssqlserver.jar,msutil.jar)<br />
in the lib of runtime and webViewer but in vein...<br />
<br />
<br />
i need Help in the basic configuration may be....<br />
Thanks for Any kind of help in advance

MarcinK

Hi Amninder,
it looks like your odbc connector is not configured properly.
Try to run report from designer in web viewer first once you have it done use runtime to automate report production.

Kind regards,
Marcin K.