I have Crystal Reports 11 installed and am trying to create a JDBC connection to a Microsoft SQL Server 2008 R2 database.  But I get the "JDBC Driver not found" error when I attempt to do this.

 

I've copied the sqljdbc.jar file (the Microsoft JDBC Driver 4) to C:\Program Files\Common Files\Business Objects\3.0\java\lib\external\ and have updated the C:\Program Files\Common Files\Business Objects\3.0\java\CRConfig.xml file to so that the sqljdbc.jar file is in the Classpath, but I'm still getting this error.

 

For the <JavaDir> I have it pointing to C:\Program Files\Business Objects\JRE\bin\ which has JRE 1.4.2 installed there.

 

I'm wondering if there's anything else I can check? 

 

Thanks in advance!

AC

 

1. There are docs that incorrectly specify the driver class name.

This is the correct class name:

Correct Class name:  note sqlserver.jdbc not jdbc.sqlserver

<JDBCClassName>com.microsoft.sqlserver.jdbc.SQLServerDriver</JDBCClassName>

Using the class name shown in the doc will give you the infamous

JDBC driver not found error 

This is the link to the latest Microsoft JDBC driver:

http://www.microsoft.com/en-ca/download/details.aspx?id=11774 - http://www.microsoft.com/en-ca/download/details.aspx?id=11774

 

2. If you get the following error when creating Crystal Reports using the JDBC driver for Microsoft Sql Server Database based on stored procedures:

Failed to retrieve data from the database

Details: Exception: [Error Message: ]null

Add the statement

set nocount on

to the stored procedure. This error is caused by the the row count being sent back as part of the result set.