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

Set up a JDBC connection to MS SQL 2005

47 Views

Hi,

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.

---------------------------

OK

---------------------------

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

CRConfig.txt.zip (1.1 kB)