Sun.jdbc.odbc.jdbcodbcdriver For Ms Access
IReport.:Tutorial Three Tutorial Three: How to use a database like MS Access via ODBC bridge with iReport 0.0.6 Please note that form iReport 0.0.8 this 'trick' is no more useful and all JDBC access are maded using pure java. In this tutorial we will see how to configure iReports for use a ODBC driver. Microsoft JVM is not compatible with java.sun.jdbc.odbcBridge class (One of the many debatable defects of the Microsoft java implementation).
Jdbc Odbc Driver
For this reason, the use of a ODBC driver is a bit complex in iReport. As we will see, the adopted solution will be the creation of two database connections, one Microsoft compatible and one Java 'Sun' compatible. We will use the first inside of iReport, the second out iReport ( for compilation and preview). Step1: creation of connections 1) Create an ODBC connection (i.e. An Microsoft Access System Data Source Name named 'TESTiReport') 2) Open iReport and select database-connections menu 4) Create two connection with follow parameters.