JDBC connection for MS SQL (sqljdbc41.jar) not working with Crystal 2013 sp1

[Former Member]

I have tried to get JDBC working by following the Microsoft instructions, and the Crystal instructions. No Luck. Cut from CRConfig::

[Former Member]

Hi Mark,

Installation of jdbc driver

1. Download a supported 32 bit JDBC connector from the vendor website and install it to the default path.
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.

4. 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: 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:sqlserver://VANPGDBSQL03.pgdev.sap.corp:1433

• Database Classname: select the classname from the table below

                (example: com.microsoft.sqlserver.jdbc.SQLServerDriver

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

More information: JDBC Connectivity for SAP Crystal Reports

I hope this information helps to resolve your problem.

Regards,
István