SLQ Server JDBC within BIRT on ReqWeb..??

qtrchicken

I've designed a report that accesses the SQL Server DB behind my ReqWeb 7.1. It's using the MS JDBC driver to connect. However, it appears that I can't do the same thing on the Websphere server. I have copied the sqljdbc4.jar files to every directory that seems logical, but I keep getting the following errors.

Cannot open the connection for the driver: org.eclipse.birt.report.data.oda.jdbc
Cannot load JDBC Driver class: com.microsoft.sqlserver.jdbc.SQLServerDriver

The report seems to fail just when data is about to be queried. Using the Rational ODA JDBC is a PIA, since I've already written most of the raw sql to retrieve my report data.

Any way I can use the MS Native JDBC for SQL Server Access?

Thanks!

qtrchicken

I figured it out. You have to put the slqjdbc jar file in the drivers folder on the server in all places. It probably only needs to go in one spot under the WEB-INF folder, but I put it in all the locations that also had the default birt jar file.