Show
Introduction to MySQL ODBC DriverODBC or MySQL connector represents the collection of the MySQL ODBC drivers. MySQL ODBC drivers were called as myODBC drivers in the early days. MySQL ODBC driver is responsible for making it possible to access the MySQL database with the help of open database connectivity API (ODBC API). The latest version of ODBC i.e. ODBC 8.0 comes with the facility of having Unicode and ANSI driver. We can use the native interface of driver-manager based interfaces to connect to the MySQL database when we use the MySQL ODBC driver. This driver provides complete support for all the MySQL functionalities such as transaction and stored procedures. If we use an ODBC driver with a 5.1 or higher version, we also get complete Unicode compliance with MySQL. When we use the Windows platform on our machine, we need to install the ODBC driver to connect to MySQL from a certain application. While using the Mac or Linux/Unix platform, named pipes of native MySQL network can be used for communication between the applications and MySQL database. Sometimes, the application that you are using on Linux/Unix or Mac os demands the usage of the ODBC interface to communicate with the database, at that time it is required to install the MySQL ODBC driver on that platforms too. Applications such as Filemaker Pro, Microsoft office and ColdFusion require ODBC for communication with MySQL. Downloading ODBC Connector/DriverYou can download the latest version of the ODBC driver that will support your MySQL version for the platform you are using by going to the following link – https://downloads.MySQL.com/archives/c-ODBC/. You need to specify the version of the ODBC driver you want to download and mention the operating system you are using and the version of the operating system. After choosing all these parameters, your file will be ready for download. All you need to do is to click on the download button. MySQL ODBC driver is licensed under GPL and is completely open-source. For windows machine, we have entered the following details as per my platform. Installation MethodsYou can install MySQL ODBC driver on your platform by using any one of the methods from the two methods mentioned below:
Installation StepsGiven below are the installation steps: Step #1 – Double-click on the file that is downloaded in MSI format. In my case, the file that got downloaded is named MySQL-connector-ODBC-5.3.2-win32.msi. The output that can be seen after double-clicking is as follows – Click on run. Step #2 – Next, you will see setup of wizard for ODBC driver as shown below. Click on next. Step #3 – Agree the license agreement and click on next. Step #4 – You can choose any of the option as per your need – typical, custom or complete. Select Typical option and click on next. Step #5 – There you go. Program is ready for installation. Click on the install button. Step #6 – Now, click on the finish button to complete installation. Configuration of ODBC DriverAfter completing the installation, we will need to configure the ODBC driver and its related connections. For this, we will need to follow the following steps: Step #1My platform is Windows 7, so to configure ODBC connections, Got to start button, click on it, and then choose Control Panel option. After that select System and Security option that further opens to a list from which we need to select Administrative Tools and then finally click Data Sources (ODBC). This will lead to pop up of the following window. Step #2Now, you will need to click on the Add button and select the ODBC 5.3 option from the list as shown below. Step #3After clicking on the finish button, you will need to specify the fields that will be needed for configuring the DSN connection using the window of connection parameters as shown below.
Step #4Now, click on the test button after entering the above details to check whether the database connection is getting pinged properly as shown below. Step #5If you want to enter other DSN details click on the details button located below as shown below. Step #6You can even specify other network details related to secure socket layer by clicking on the ssl button shown below. The connection is now ready. You can use the connection in different applications such as Microsoft Excel, Word to connect the database and retrieve data and manipulate the same. ConclusionWe can use the ODBC driver of MySQL to establish a connection with MySQL database from any many applications. You can easily install it when you want to use it by following the above steps in the windows platform. Recommended ArticlesThis is a guide to MySQL ODBC Driver. Here we discuss how to download ODBC connector/driver, with installation methods, steps and configuration of ODBC driver. You may also have a look at the following articles to learn more –
Is there an ODBC driver for MySQL?MySQL Connector/ODBC 8.0 is recommended for use with MySQL Server 8.0, 5.7, and 5.6.
Where is MySQL ODBC driver located?64-Bit Windows and ODBC Data Source Administrator
On Windows x64 editions, the Connector/ODBC driver is installed in the %SystemRoot%\SysWOW64 folder.
How do I download and install ODBC Drivers?Go to Start > Settings > Control Panel.. Open the ODBC icon.. The User DSN tab appears. Click Add.. The Create New Data Source window appears. Select the appropriate driver and click Finish. ... . The Data Source Setup window appears for that driver. ... . Click Select.. The Select Database window opens. ... . Click OK.. How do I create an ODBC connection for MySQL in Windows 10?To set up a new ODBC data source for MySQL Server:. Install the latest MySQL ODBC drivers: ... . Open the 64 bit ODBC Administrator: ... . Open the System DSN tab and click Add:. Choose the latest MySQL ODBC driver and click Finish:. Enter the ODBC credentials: ... . Test the data source connection:. |