Skip to Content
Jul 10, 2012 at 04:34 AM

Set up a JDBC connection to MS SQL 2005



I am seeking some information on how to setup a JDBC connection from within Crystal Reports XI Release 2.

I have managed to get it to work in an Evaluation copy of CR 2011, but I would hopefully like to avoid the cost of purchasing a new IDE at this time.

The database is a MS SQL 2005 database connection with the Microsoft JDBC Driver ( sqljdbc4.jar ).

I think I need a little assistance in setting up the CRConfig file found in

C:\Program Files\Business Objects\Common\3.5\java

The error I receive is:


Crystal Reports


Invalid Argument provided.

Details: Java Server startup failure. Please verify the PATH (JDK), CLASSPATH and IORFileLocation properties in the CRConfig.xml file. In addition, please verify you are using JDK 1.4.




note that I use JRE7 ( this works for CR 2011, and as I udertand it it JRE6 or higher is needed by sqljdbc4.jar )

Please see CRConfig.XML attached.

Any tips?

Message was edited by: Scott Thornton ( removed keycode from file)

Attachments (1.1 kB)