I. Overview
1. Application scenarios
FineReport10.0 has built-in JDK1.8 or JDK 11, which do not support direct connection to ODBC data sources. If you connect to the ODBC data source directly on the platform, you will receive the following error message:
So how does 10.0 designer connect to ODBC? More on this below.
2. Environment preparation
Download the file and unzip it: Driver.zip
Place the two files in corresponding paths:
Place jdbcOdbc.dll under%FineReport_10.0%\jre\bin, and place jdbc.jar under %FineReport_10.0%\webapps\webroot\WEB-INF\lib.As shown below:
Note: If the report project is deployed on a server, such as a Tomcat server, you need to place jdbc.jar and jdbcOdbc.dll in the lib and bin directories of the Tomcat respectively.
3. Configuration information
To create a JDBC data connection in the designer, the basic configuration information is as follows:
Database | Driver | URL |
---|---|---|
others | sun.jdbc.odbc.JdbcOdbcDriver | jdbc:odbc:data source name |
II. Steps
1) Taking the local ODBC connection as an example, configure a local ODBC data source fr, as shown in the figure below:
2) Click Server > Define Data Connection in the designer menu bar, add a JDBC data connection, change the data connection name to ODBC, fill in the configuration information, click Test Connection, click OK after successfully connected to save.