[Designer] ODBC Data Connection

Application Scenario

This document introduces how to connect FineReport to an ODBC database.

Environment Preparation

Download the file and decompress: Compressed Package.rar

After decompression, place the jdbcOdbc.dll file to %FineReport_11%\jre\bin, and place the jdbc.jar file to %FineReport_11%\webapps\webroot\WEB-INF\lib, as shown in the following figure.

Note:

If the report project is deployed on a server, for example, a Tomcat server, in addition to the steps mentionedabove, you also need to place the jdbc.jar file and the JdbcOdbc.dll file to the lib directory and   the bin directory of the Tomcat server respectively. You need to restart the Tomcat server before testing if you can connect to the ODBC server for access data.

Configuration Information

Create a JDBC data connection in the designer. The following table shows the basic configuration information.

1. Take the local ODBC connection as an example. Configure a local ODBC data source fr, as shown in the following figure.

2. On the designer menu bar, choose Server > Define Data Connection, add a JDBC data connection, rename the data connection ODBC, fill in the configuration information, and click Test Connection. After the data connection is successful, click OK.