on 07-10-2012 5:34 AM
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)
Hi Scott,
The <JDBCURL> and the <JDBCClassName> in your CRConfig.XML file do not look familiar to me!
I guess they should be:
<JDBCURL>jdbc:microsoft:sqlserver://SERVERNAME:PORTNUMBER</JDBCURL>
and
<JDBCClassName>com.microsoft.jdbc.sqlserver.SQLServerDriver</JDBCClassName>
Also, do you really need quotes around the Path to the .jar file in the Classpath? Try removing them too.
Let me know how this goes!
-Abhilash
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
HI Abhilash,
Thanks very much for your reply.
I changed the variables as indicated by yourself to read:
<JDBCURL>jdbc:microsoft:sqlserver://myserver:1433;databaseName=mydatabase</JDBCURL>
<JDBCClassName>com.microsoft.jdbc.sqlserver.SQLServerDriver</JDBCClassName>
and the same error occurs as listed above.
The Original format I supplied successfully works in Crystal 2011 I should point out.
I believe the change may be related to the new driver from Microsoft, but as I have read so many webpages and googled so much that last few days I can't reliable point out where I obtained this information.
The connection strings I supplied work both in Crystal 2011 and when supplied via .jsp when using CR4E ( Crystal Reports for Eclipse), just not in XI R2.
Do you know of any logging occurs when the attempt to connect to JDBC occurs in the IDE? I couldn't find any.
Hi Scott,
I'm sorry, I just looked at my ClassPath and it looks this:
C:\SQL_JDBC\sqljdbc_3.0\enu\sqljdbc.jar
The JDBCURL and JDBCClassName look like this:
<JDBCURL>jdbc:sqlserver://mydbserver:1433</JDBCURL>
<JDBCClassName>com.microsoft.sqlserver.jdbc.SQLServerDriver</JDBCClassName>
So, what you had originally in there is correct.
I just looked at a few SAP Notes and it seems this could be because the JAVA_HOME system variable is not defined (Just a thought).
Could you have a look at that perhaps?
-Abhilash
Good Morning,
I managed to get it working.
I had copied a colleagues CRConfig.xml to my PC. He must not have installed Release 2 as the paths were different.
I confirmed that each file existed and my class path now reads:
<Classpath>C:\Program Files\Business Objects\Common\3.5\java\lib\crlovmanifest.jar;C:\Program Files\Business Objects\Common\3.5\java\lib\CRLOVExternal.jar;C:\Program Files\Business Objects\Common\3.5\java\lib\CRDBJavaServerCommon.jar;C:\Program Files\Business Objects\Common\3.5\java\lib\CRDBJavaServer.jar;C:\Program Files\Business Objects\Common\3.5\java\lib\CRDBJDBCServer.jar;C:\Program Files\Business Objects\Common\3.5\java\lib\CRDBXMLServer.jar;C:\Program Files\Business Objects\Common\3.5\java\lib\CRDBJavaBeansServer.jar;C:\Program Files\Business Objects\Common\3.5\java\lib\external\CRDBXMLExternal.jar;C:\Program Files\Business Objects\Common\3.5\java\lib\external\log4j.jar;C:\Program Files\Business Objects\Common\3.5\java\lib\cecore.jar;C:\Program Files\Business Objects\Common\3.5\java\lib\celib.jar;C:\Program Files\Business Objects\Common\3.5\java\lib\ebus405.jar;C:\Program Files\Business Objects\Common\3.5\java\lib\corbaidl.jar;C:\Program Files\Business Objects\Common\3.5\java\lib\external\freessl201.jar;C:\Program Files\Business Objects\Common\3.5\java\lib\external\asn1.jar;C:\Program Files\Business Objects\Common\3.5\java\lib\external\certj.jar;C:\Program Files\Business Objects\Common\3.5\java\lib\external\jsafe.jar;C:\Program Files\Business Objects\Common\3.5\java\lib\external\sslj.jar;"C:\Program Files\Microsoft SQl Server JDBC Driver\sqljdbc_2.0\enu\sqljdbc.jar";${CLASSPATH}</Classpath>
User | Count |
---|---|
101 | |
13 | |
13 | |
11 | |
11 | |
7 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.