Kbase P112528: How to configure Crystal Reports 10 to connect to a Progress database via JDBC
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
1/12/2007 |
|
Status: Unverified
GOAL:
How to configure Crystal Reports 10 to connect to a Progress database via JDBC
FACT(s) (Environment):
OpenEdge 10.x
Crystal Reports 10
Windows
FIX:
Business Objects has made JDBC connectivity available to Crystal Reports 10 as an add-in feature.
In order to configure Crystal Reports 10, please follow the steps detailed in the Business Objects article "Configuring JDBC (JNDI) connectivity in Crystal Reports 10".
After following the steps detailed in this document, the option for JDBC (JNDI) connections will be available within Crystal Reports 10.
Once installed, the file CRDB_JavaServer.ini (normally located in C:\Program Files\Common Files\Crystal Decisions\2.5\bin\) can be configured to reference the Progress JDBC driver, otherwise the JDBC URL and JDBC driver name will have to be entered manually.
The following is an example of the CRDB_JavaServer.ini file configured for use with the OpenEdge 10.0B JDBC driver against a generic Sports2000 database. Items in bold should be modified to suit the specific configuration and driver version.
[Common]
PATH = DLC\jdk\bin
CLASSPATH = C:\Program Files\Common Files\Crystal Decisions\2.5\bin\CRDBJavaServer.jar;C:\Program Files\Common Files\Crystal Decisions\2.5\java\lib\external\CRDBXMLExternal.jar;DLC\java\jdbc.jar;DLC\java\prosp.jar;DLC\java\progress.jar;DLC\java;DLC\jre\lib\rt.jar;${CLASSPATH}
IORFileLocation = C:\TEMP
JavaServerTimeout = 1800
JVMMaxHeap = 64000000
JVMMinHeap = 32000000
[CRDB_JDBC]
CacheRowSetSize = 100
JDBCURL = jdbc:jdbcprogress:T:localhost:9999:sports2000
JNDIURL =
JDBCUserName = pub
JDBCDriverName = com.progress.sql.jdbc.JdbcProgressDriver
JNDIUserName = weblogic
JNDIConnectionFactory =
JNDIInitContext = /
GenericJDBCDriverBehavior = Oracle
[CRDB_XML]
PREREADNBYTE = 5000
CacheRowSetSize = 100
XMLLOCALURL =
SCHEMALOCALURL =
XMLHTTPURL =
SCHEMAHTTPURL =
USETEMPFile = TRUE