Tag: ODBC connection with MySql Database

Posted on by — Leave a comment

Create ODBC connection with MySQL

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