CrystalReport 2011 - JDBC driver not found

最新推荐文章于 2023-03-27 17:31:48 发布

CPP_CHEN

最新推荐文章于 2023-03-27 17:31:48 发布

阅读量2.4k

点赞数

分类专栏： Oracle 文章标签： jdbc sap x86 oracle download database

本文链接：https://blog.csdn.net/CPP_CHEN/article/details/7699036

版权

Oracle 专栏收录该内容

23 篇文章 0 订阅

订阅专栏

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