www.sheroz.com
Home
Crystal Reports 2008 with MySQL and Oracle Databases ( Failed to open
the connection. Details: JDBC driver not found )
Crystall Reports Jav a jdbc linux mysql Oracle Windows
I tried Crystal Reports 2008 to connect MySQL database through JDBC and got following error:
"Failed to open the connection. Details: JDBC driver not found".
After some research found this way to fix this issue:
1. Download the MySQL JDBC driver from http://www.mysql.com/downloads/connector/j/
In my case it was mysql-connector-java-5.1.7.jar
2. Add the JDBC driver to the Classpath node in crystal reports config file CRConfig.xml. The CRConfig.xml file by default
located in: "C:\Program Files\Business Objects\Common\4\java\CRConfig.xml"
I copied downloaded jar file to "C:\Program Files\Business Objects\Common\4\java\lib" directory, but it is not necessary,
just for keeping things together
After adding JDBC driver the Classpath looks like:
<Classpath>C:\Program Files\Business Objects\Common\4.0\java/lib/mysql-connector-java-5.1.7.jar;C:\Program
Files\Business Objects\Common\4.0\java/lib/crlovmanifest.jar;C:\Program Files\Business Objects\Common\4.0\java/lib
/CRLOVExternal.jar;C:\Program Files\Business Objects\Common\4.0\java/lib/CRDBJDBCServer.jar;C:\Program
Files\Business Objects\Common\4.0\java/lib/CRDBXMLServer.jar;C:\Program Files\Business Objects\Common\4.0\java/lib
/CRDBJavaBeansServer.jar;C:\Program Files\Business Objects\Common\4.0\java/lib/external/CRDBXMLExternal.jar;C:
\Program Files\Business Objects\Common\4.0\java/lib/external/log4j.jar;C:\Program Files\Business Objects\Common
\4.0\java/lib/CRDBSForceServer.jar; C:\Program Files\Business Objects\Common\4.0\java/lib/external
/CRDBSForceExternal.jar;${CLASSPATH}</Classpath>
3. Save CRConfig.xml file and restart Crystal Reports (close and open).
4. Now you should be able to connect database through JDBC. On Database Expert select Create New Connection option
and click on JDBC(JNDI). On Connection dialog use Connection URL as "jdbc:mysql://localhost:3306/db" (database host
Ads by Google
MySQL Oracle JDBC Java Oracle XML to MySQL Job in MySQL
Navigation
Home
About me
CV
Portfolio
Articles
Contact
Crystal Reports 2008 with MySQL and Oracle Databases ( Failed to open the connection
. Details...
http://www.sheroz.com/articles/crystal-reports-2008-mysql-and-oracle-databases
1 of 5
10/29/2010 8:58 PM
name or ip for localhost and database name for db) and Database Classname: "com.mysql.jdbc.Driver".
5. Click next and enter database user and password.
Job Board
Remedy Developer
Miami, FL
Vitaver & Associates, Inc.
Programmer
Coral Gables, FL
University of Miami Libraries
Sales Executive
Miami, FL
Web Developer
Miami, FL
Vitaver & Associates, Inc.
Lead, Web Infrastructure
Crystal Reports
Download
Explore the Latest
Reporting
Technology.
Download a Free
Trial.
Miami Dade College
Fast, affordable, IT
training. Get A+
certified now.
mdc.edu/itcareers
Crystal Scheduler
Easy Crystal Report
Scheduler Free Trial
Available
www.ripplestone.com
Crystal Reports
Training
Report Design: public,
private & virtual class
options. Register at
www.Kogent360.com
Recommended
Download
Free Registry Scan,
Fix Errors & Improve
Performance - 5 Star
Rated
www.PCTools.com
Crystal Reports 2008 with MySQL and Oracle Databases ( Failed to open the connection
. Details...
http://www.sheroz.com/articles/crystal-reports-2008-mysql-and-oracle-databases
2 of 5
10/29/2010 8:58 PM
6. Click finish and you should see your database tables
Services
Miami, FL
Sales Executive
Miami, FL
Senior Oracle Identity
Management...
West Palm Beach, FL
Government
Perl Developer Information
Systems
Boca Raton, FL
ConsultNet
Blackberry Messaging
Administrator
Boca Raton, FL
ConsultNet
Perl Developer Information
Systems
Boca Raton, FL
Consultnet
POST A JOB >
POWERED BY JOBTHREAD
Hibernate Spring MVC
netBeans Maven JBoss
Struts2 Portlets Security
log4j Web Jabber
mysql Microsoft Visual
C++ Unix C++
Cryptography sql Java EE
linux Struts Server
Spring WS C SOAP
Windows Java
Tomcat fedora Spring
Database network
Java Web TCP/IP
Oracle Spring Security
jdbc Subversion Swing
JPA Web Services
more tags
Crystal Reports 2008 with MySQL and Oracle Databases ( Failed to open the connection
. Details...
http://www.sheroz.com/articles/crystal-reports-2008-mysql-and-oracle-databases
3 of 5
10/29/2010 8:58 PM
The same way I successfully connected Crystal Reports 2008 to Oracle 11g database, JDBC driver ojdbc14.jar,
Connection URL="jdbc:oracle:thin:@localhost:1521:db" and Database Classname = "oracle.jdbc.driver.OracleDriver"
Add new comment
.
Similar entries
Articles
Portfolio / Developed Software
CV - Java, C, C++ and SQL programmer
MS Access and DBF files with a long filename ( Run-time error 3011: The Microsoft Jet database engine could not find
the object )
Crystal Reports 2008 with MySQL and Oracle Databases ( Failed to open the connection
. Details...
http://www.sheroz.com/articles/crystal-reports-2008-mysql-and-oracle-databases
4 of 5
10/29/2010 8:58 PM
Linux WiFi installation (Fedora 13 on Asus F3S)
All logos, brands, product names and trademarks are the property of their respective owners.
Thank you for visiting :)
Oracle Testing www.focusframe.com/Solutions
Reduce Scripting efforts by 40% Performance
& Security Testing
.RPT File Viewer www.TheReportViewer.com
Free Download. Full of Features. Professional
Software. Easy to use.
Oracle Database Upgrade www.cintra.com
Cintra - Premier Oracle Partner Offers Free
Upgrade Assessment
Profile Running Java App www.NewRelic.com
See all code in running app Free tool installs in
2 minutes
Crystal Reports 2008 with MySQL and Oracle Databases ( Failed to open the connection
. Details...
http://www.sheroz.com/articles/crystal-reports-2008-mysql-and-oracle-databases
5 of 5
10/29/2010 8:58 PM
