iReport Designer IngresDriver

[kz25]

I am attempting to create a "Database JDBC connection" with Jaspersoft Designer 3.7.6.  When I specify JDBC Driver as "Ingres (com.ingres.jdbc.IngresDriver)", the server adrres, URL, and click on Test I get an error:

ClassNotFoundError!
Msg: com.ingres.jdbc.IngresDriver
Possible not found class: com.ingres.jdbc.IngresDriver
...

Does this mean the this tool does not have this driver.  How would I add this driver so this tool can connect to the database?

 

[cbarlow3]

I've never worked with the Ingres driver before, but when I have someone install iReport and they have to use a special database driver (IBM DB2 Universal Driver, in our case), I first have to register the database driver through the services window  as follows:

1. Make sure you know where the jar file is on your PC (in my case, it's a file called db2jcc.jar)

2. In iReport, Window | Services

3. Select databases node and expand it.

4. Select Drivers node, right click it, and select "New Driver"

5. Add the driver, using the "Browse" button to find the jar file.

 

From then on, when you add a new connection, you should change the dropdown "Name:" from the default of "JDBC-ODBC Bridge" to the database driver of your choice (which should appear in the dropdown now that you've registered it).

Hope that helps.

Carl