I. Overview
1. Product Introduction
Microsoft Office Access is a database management system that Microsoft combines the graphical user interface of the database engine with software development tools. So how to connect to the Access database in FineReport? This article will introduce to you.
Note: This method only works with the 10.0 (64-bit) designer.
2. Choose the connection method
There are two ways to connect to Access:
One is to use ODBC for Access data connection. Reference Documentation: [Designer] ODBC Data Connection
The second is to directly connect to the Access data. Please refer to the following for the operation steps.
II. Steps
1. Add driver
1) Download the third-party JDBC driver for connecting to the Access database, UCanAccess:
2) Unzip the downloaded compressed package, and place the ucanaccess-4.0.4.jar in the root directory of the compressed package and the four JAR packages in the lib directory in the %FR_HOME%\webapps\webroot\WEB-INF\lib folder . As shown below:
3) The designer must be restarted to take effect.
2. Create a new data connection
1) Open the designer and define the data connection.
2) Select the database as "Others".
2) Modify the drive. Copy net.ucanaccess.jdbc.UcanaccessDriver and paste it into the drive column.
3) The URL is modified to the path where the jdbc:ucanaccess://access database is located (supports .accdb, .mdb)
4) Click Connection Pool Attributes and confirm that Test before Ruturning Connections is set to No, as shown in the following figure:
3. Test connection and complete the settings
