Jaspersoft Studio 6.2.0 Setting up Connection

-1

I am trying to set up a connection using the Data Adapter but to no avail.

Driver: sun.jdbc.odbc.jdbcOdbcDriver

I have a DNS set up to a db2 database(Has worked in iReport 2.3 and 5.6)

When I test I get ClassNotFoundException sun.jdbc.odbc.jdbcOdbcDriver cannot be found by net.sf.jasperreports_6.2.0.final

steve.dyke's picture
Joined: Nov 27 2012 - 2:51pm
Last seen: 1 year 4 weeks ago

3 Answers:

1

This probably isn't a JasperReports problem but with the JDK. Oracle decided to drop jdbc-odbc bridge. You'll need to get a different jdb-odbc bridge. You'll be able to find them by googling.

hozawa's picture
52362
Joined: Apr 24 2010 - 4:31pm
Last seen: 5 months 5 days ago
0

I have the jt400.jar file but how do I get the JasperSoft Studio to see it?

steve.dyke's picture
Joined: Nov 27 2012 - 2:51pm
Last seen: 1 year 4 weeks ago
0
On the Data Adapter Dialog (once you select Database JDBC Connection) you can add the driver JAR path in the "Driver Classplath" tab.
Or you can add the jar to project classpath in a standard eclipse way, in this way driver will be visible inside your project
 
marianol's picture
4768
Joined: Sep 13 2011 - 8:04am
Last seen: 1 year 1 month ago
Feedback
randomness