Data Connectivity
 Crystal Reports Forum : Crystal Reports 9 through 2020 : Data Connectivity
Message Icon Topic: JDBC driver not found Post Reply Post New Topic
Author Message
CTTDEV
Newbie
Newbie


Joined: 07 Sep 2012
Online Status: Offline
Posts: 4
Quote CTTDEV Replybullet Topic: JDBC driver not found
    Posted: 07 Sep 2012 at 2:19pm
Hello,
 
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
IP IP Logged
Mark Farris
Newbie
Newbie


Joined: 13 Dec 2012
Location: United States
Online Status: Offline
Posts: 1
Quote Mark Farris Replybullet Posted: 13 Dec 2012 at 4:23am
Here are a couple of tips when using the Microsoft JDBC driver
 
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 

That you are reporting

This is the link to the latest Microsoft JDBC driver:

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.

 
Mark Farris
IP IP Logged
Post Reply Post New Topic
Printable version Printable version

Forum Jump
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum



This page was generated in 0.031 seconds.