Status: Unverified
GOAL:
How to configure Crystal Reports XI to connect to a Progress database via JDBC
GOAL:
How to configure Crystal Reports 11 to connect to a Progress database via JDBC
FACT(s) (Environment):
OpenEdge 10.x
Crystal Reports 11 (XI)
Windows
FIX:
In order to use JDBC to connect to Crystal Reports XI, the file CRConfig.xml (normally located in C:\Program Files\Common Files\Business Objects\bin\3.0\java) must be configured to reference the Progress JDBC driver, otherwise the JDBC URL and JDBC driver name will have to be entered manually. For more information about the CRConfig.xml file, please refer to the Business Objects article "Creating JDBC Connections in Crystal Reports XI".
The environment of the PC must also be configured correctly to ensure that Progress is able to locate all files and drivers. The required Environment Variables can be found in the file SQL_ENV.BAT located in DLC\Bin. Alternatively, a new version of SQL_ENV.BAT can be created and a line added to launch Crystal Reports XI can be added after the "echo DONE setup the sql environment" statement.
The following is an example of the CRConfig.xml file configured for use with the OpenEdge 10.1A JDBC driver against a generic Sports2000 database. Items in bold should be modified to suit the specific configuration and driver version.
<?xml version="1.0" encoding="utf-8"?><CrystalReportEngine-configuration>
<reportlocation>../..</reportlocation>
<timeout>10</timeout>
<ExternalFunctionLibraryClassNames>
<classname> </classname>
<classname> </classname>
</ExternalFunctionLibraryClassNames>
<keycode><Crystal Control Code></keycode>
<Javaserver-configuration>
<DataDriverCommon>
<JavaDir>DLC\jdk\bin</JavaDir>
<Classpath>C:\Program Files\Common Files\Business Objects\3.0\java/lib/crlovmanifest.jar;C:\Program Files\Common Files\Business Objects\3.0\java/lib/CRLOVExternal.jar;C:\Program Files\Common Files\Business Objects\3.0\java/lib/CRDBJavaServerCommon.jar;C:\Program Files\Common Files\Business Objects\3.0\java/lib/CRDBJavaServer.jar;C:\Program Files\Common Files\Business Objects\3.0\java/lib/CRDBJDBCServer.jar;C:\Program Files\Common Files\Business Objects\3.0\java/lib/CRDBXMLServer.jar;C:\Program Files\Common Files\Business Objects\3.0\java/lib/CRDBJavaBeansServer.jar;C:\Program Files\Common Files\Business Objects\3.0\java/lib/external/CRDBXMLExternal.jar;C:\Program Files\Common Files\Business Objects\3.0\java/lib/external/log4j.jar;C:\Program Files\Common Files\Business Objects\3.0\java/lib/cecore.jar;C:\Program Files\Common Files\Business Objects\3.0\java/lib/celib.jar;C:\Program Files\Common Files\Business Objects\3.0\java/lib/ebus405.jar;C:\Program Files\Common Files\Business Objects\3.0\java/lib/corbaidl.jar;C:\Program Files\Common Files\Business Objects\3.0\java/lib/external/freessl201.jar;C:\Program Files\Common Files\Business Objects\3.0\java/lib/external/asn1.jar;C:\Program Files\Common Files\Business Objects\3.0\java/lib/external/certj.jar;C:\Program Files\Common Files\Business Objects\3.0\java/lib/external/jsafe.jar;C:\Program Files\Common Files\Business Objects\3.0\java/lib/external/sslj.jar;DLC\java\prosp.jar;DLC\java\jdbc.jar;DLC\java\progress.jar;DLC\java;DLC\jre\lib\rt.jar;${CLASSPATH}</Classpath>
<IORFileLocation>${TEMP}</IORFileLocation>
<JavaServerTimeout>1800</JavaServerTimeout>
<JVMMaxHeap>64000000</JVMMaxHeap>
<JVMMinHeap>32000000</JVMMinHeap>
<NumberOfThreads>100</NumberOfThreads>
</DataDriverCommon.>
<JDBC>
<CacheRowSetSize>100</CacheRowSetSize>
<JDBCURL>jdbc:datadirect:openedge://localhost:9999;databaseName=sports2000</JDBCURL>
<JDBCClassName>com.ddtek.jdbc.openedge.OpenEdgeDriver</JDBCClassName>
<JDBCUserName>pub</JDBCUserName>
<JNDIURL></JNDIURL>
<JNDIConnectionFactory></JNDIConnectionFactory>
<JNDIInitContext>/</JNDIInitContext>
<JNDIUserName>weblogic</JNDIUserName>
<GenericJDBCDriver>
<Option>yes</Option>
<DatabaseStructure>schemas,tables</DatabaseStructure>
<StoredProcType>Standard</StoredProcType>
<LogonStyle></LogonStyle>
</GenericJDBCDriver>
</JDBC>
<XML>
<CacheRowSetSize>100</CacheRowSetSize>
<PreReadNBytes>4096</PreReadNBytes>
<XMLLocalURL></XMLLocalURL>
<SchemaLocalURL></SchemaLocalURL>
<XMLHttpURL></XMLHttpURL>
<SchemaHttpURL></SchemaHttpURL>
</XML>
<JavaBeans>
<CacheRowSetSize>100</CacheRowSetSize>
<JavaBeansClassPath></JavaBeansClassPath>
</JavaBeans>
</Javaserver-configuration>
</CrystalReportEngine-configuration>.