TimPeters Posted February 8, 2007 Share Posted February 8, 2007 I have just downloaded and installed ireports. I have Microsoft SQL 2000 and SQL 2005 databases. I've downlaoded the SQL 2005 JBDC driver and copied the .jar file into the Lib directory of the Ireports folder. When I tried to make a new connection the class not found error comes up when i test. How do I fix this? Link to comment Share on other sites More sharing options...
jmurray Posted February 8, 2007 Share Posted February 8, 2007 Did you remember to copy tools.jar into your lib directory too. It's not distributed with iReports but is required if you want to start iReports because it contains all the basic java classes (like java.lang.String for example). tools.jar is distributed in the java SDK from Sun. Link to comment Share on other sites More sharing options...
TimPeters Posted February 8, 2007 Author Share Posted February 8, 2007 I did put a copy of the tools.jar in my Lib directory but still no luck. I believe that the problem stems from the sql driver. Apparently Ireport doesn't recognize the new sql 2005 .jar file named sqljdbc.jar. Once i put in the 2000 driver .jar files it recognized correctly. THis however brought me to another problem, we use both SQL 7 and SQL 2005. and the SQL 2000 or 2005 .jar files are not compatible with SQL 7. Luckily i found the jTDS driver on this site and i was able to connect to the server through that. Tim Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now