Home Java Programming Jasper Report Create ODBC connection with MySQL

Create ODBC connection with MySQL

1 min read

This tutorial will explain to you how to create an ODBC connection with the MySQL database.

  1. download and install MYSQL from the https://dev.mysql.com/downloads/windows/installer/8.0.html
  2. download ODBC connector for MYSQL https://dev.mysql.com/downloads/connector/odbc/

Creating Connection

install MySql server and ODBC connector 32bit or 64bit version.

click windows key in and type ODBC Data Source and select ODBC Datasource Administrator 32bitODBC connection

Click on add and select the MySql ODBC ANCI Driver.

finally DB connection details will appear and provide ODBC name the server as localhost, port 3306, root as user and password.

then the system will create an ODBC connection that can be used to connect to the database from various applications.

this ODBC connection will be used to create jasper report with Jasper Report Designer

Load More Related Articles
Load More By Pradeepa N Weerasinghe
Load More In Jasper Report

Leave a Reply

Your email address will not be published. Required fields are marked *

Check Also

Create a Jasper Report with My SQL

In this tutorial, I am going to talk about how to create a Jasper Report with My SQL Datab…