SAP Knowledge Base Article - Public

1527666 - How to set up a successful JDBC connection in Crystal Reports?

Symptom

  • How to configure JDBC connection for Crystal Reports 2008?
  • How to configure JDBC connection for SAP Crystal Reports 2011/2013/2016?
  • How to configure CRConfig. xml file to connect to a MySQL database using JDBC connection?
  • How to find the list of Connection URL's for creating Crystal Reports based on JDBC Connectivity with various Databases?

Environment

  • Crystal Reports 2016
  • Crystal Reports 2013
  • Crystal Reports 2011
  • Crystal Reports 2008
  • JDBC connection

 

Resolution

Installation of jdbc driver

1. Download a supported 32 bit JDBC connector from the vendor website and install it to the default path. For some vendors it is important to install and not only copy and paste the required files.
2. Edit the CRConfig.xml file from the Crystal reports installation target path.
3. Edit the <Classpath> tag  to add the location of the jar file before existing entries. (In the following example you see MySQL driver)
odbc-mysql.jpg

Make sure to update the Classpath with links to all drver files. For example, for DB2 paths for the following jar files are required: db2jcc4.jar, db2jcc_license_cisuz.jar (see Vendor's instruction).

Save the file and restart Crystal Report application.

    • Path to CRConfig.xml for CR2008: C:\Program Files (x86)\Business Objects\Common\4.0\java\
    • Path to CRConfig.xml for CR2011, CR2013, CR2016: C:\Program Files (x86)\SAP BusinessObjects\\SAP BusinessObjects Enterprise XI 4.0\java\

Configure JDBC connection in Crystal Reports

1. From Crystal Reports, create a new report (File>New>Blank Report)
2. In Database Expert window click on “Create New Connection”
3. Locate “JDBC” and click on “Make New Connection”.
4. In the connection wizard screens complete the following information

    • Connection URL: example: select the connection URL from the table below (example: jdbc:oracle:thin:@myservername:1521:myservice)
    • Database Classname: select the classname from the table belov (example: oracle.jdbc.driver.OracleDriver)

2015-12-14- 16-51-10.png

The following table contains connection URL-s for different database types

 

Database Name Connection URL Database Classname
ODBC jdbc:odbc:DSN-name sun.jdbc.odbc.JdbcOdbcDriver
Oracle jdbc:oracle:thin:@<server-name>:[port]:<service-name> oracle.jdbc.driver.OracleDriver
SQL Server 2000 jdbc:microsoft:sqlserver://<server-name>:[port] com.microsoft.jdbc.sqlserver.SQLServerDriver
SQL Server 2005/2008 jdbc:sqlserver://<server-name>:[port] com.microsoft.sqlserver.jdbc.SQLServerDriver
Derby jdbc:derby:/test;create=true org.apache.derby.jdbc.EmbeddedDriver
DB2 jdbc:db2://<server-name>:<port-number>/<database_name>

com.ibm.db2.jcc.DB2Driver

MySQL jdbc:mysql://<server_name>:[port]/<database_name> com.mysql.jdbc.Driver
Informix jdbc:informix-sqli://<server-name>:<port-numer>/<database-name>:INFORMIXSERVER=MyServerName com.informix.jdbc.IfxDriver
Sybase jdbc:datadirect:sybase://<server-name>:<port-number>; databaseName=name com.ddtek.jdbc.sybase.SybaseDriver
Sybase TDS

jdbc:sybase:Tds:<server_name>:<port>?ServiceName=<TDS service name>

com.sybase.jdbc4.jdbc.SybDriver

PostgreSQL

jdbc:postgresql://<server-name>:[port]/<database_name>

org.postgresql.Driver

For more Connection URL's on various Databases, please Click here.

         5. Click Next and provide your credentials as logon username and password

Keywords

Crystal Reports, XI R2/XI, JDBC Connectivity, JRC, CRJ, JDBC Connection, CR, Crystal Reports 2011, Crystal Reports 2013, Connection URL , KBA , BI-RA-CR , Crystal Reports designer or BusinessViews Manager , BI-RA-CRE , Crystal Reports for Enterprise , BI-RA-CRV , SAP Crystal Reports Viewer , How To

Product

Crystal Reports 2008 V0 ; Crystal Reports 2008 V1 ; SAP Crystal Reports 2011 ; SAP Crystal Reports 2013 ; SAP Crystal Reports XI ; SAP Crystal Reports XI R2