CrystalReport 2011 - JDBC driver not found

最新推荐文章于 2024-07-14 22:27:39 发布

原创最新推荐文章于 2024-07-14 22:27:39 发布 · 2.5k 阅读

1 ·

CC 4.0 BY-SA版权

文章标签：

#jdbc #sap #x86 #oracle #download #database

Oracle 专栏收录该内容

23 篇文章

订阅专栏

本文解决Crystal Report 2010连接OracleXE数据库时出现的JDBC驱动未找到问题。通过复制ojdbc6.jar到特定文件夹并修改CRConfig.xml文件以包含该驱动，最后重启软件即可解决问题。

While create connection to Oracle XE database, CrystalReport 2010 reports "JDBC driver not found". Here is the solution to fix this prolem.

1) copy "ojdbc6.jar" Oracle JDBC Driver to "C:\Program Files (x86)\SAP BusinessObjects\SAP BusinessObjects Enterprise XI 4.0\java\lib\external"

2) Edit "C:\Program Files (x86)\SAP BusinessObjects\SAP BusinessObjects Enterprise XI 4.0\java\CRConfig.xml" to add the ojdbc6.jar in the classpath.

<Classpath>C:\Program Files (x86)\SAP BusinessObjects\\SAP BusinessObjects Enterprise XI 4.0\java/lib/crlovmanifest.jar;C:\Program Files (x86)\SAP BusinessObjects\\SAP BusinessObjects Enterprise XI 4.0\java/lib/CRLOVExternal.jar;C:\Program Files (x86)\SAP BusinessObjects\\SAP BusinessObjects Enterprise XI 4.0\java/lib/CRDBJDBCServer.jar;C:\Program Files (x86)\SAP BusinessObjects\\SAP BusinessObjects Enterprise XI 4.0\java/lib/CRDBXMLServer.jar;C:\Program Files (x86)\SAP BusinessObjects\\SAP BusinessObjects Enterprise XI 4.0\java/lib/CRDBJavaBeansServer.jar;C:\Program Files (x86)\SAP BusinessObjects\\SAP BusinessObjects Enterprise XI 4.0\java/lib/external/log4j.jar;C:\Program Files (x86)\SAP BusinessObjects\\SAP BusinessObjects Enterprise XI 4.0\java/lib/CRDBSForceServer.jar;C:\Program Files (x86)\SAP BusinessObjects\\SAP BusinessObjects Enterprise XI 4.0\java/lib/external/CRDBSForceExternal.jar;C:\Program Files (x86)\SAP BusinessObjects\\SAP BusinessObjects Enterprise XI 4.0\java/lib/CRDBWicServer.jar;C:\Program Files (x86)\SAP BusinessObjects\\SAP BusinessObjects Enterprise XI 4.0\java/lib/external/CRDBWicExternal.jar;C:\Program Files (x86)\SAP BusinessObjects\\SAP BusinessObjects Enterprise XI 4.0\java/lib/external/CRDBXMLExternal.jar;C:\Program Files (x86)\SAP BusinessObjects\\SAP BusinessObjects Enterprise XI 4.0\java/lib/external/ojdbc6.jar;${CLASSPATH}</Classpath>

3) Close the CrystalReport 2011, reopen it and creating JDBC connection should have no problem.

You can download ojdbc6.jar from:

http://www.oracle.com/technetwork/database/enterprise-edition/jdbc-111060-084321.html