Install Connector/ODBC

Overview

MariaDB Connector/ODBC is available as a binary tarball for Linux distributions, as an MSI for Microsoft Windows operating systems, and as a PKG for Apple macOS.

Linux (Binary Tarball)

  1. Go to the MariaDB Connector/ODBC download page.

  2. In the "OS" dropdown, select your distribution of Linux.

  3. Click the "Download" button to download the file.

  4. Extract the tarball:

    $ tar -xvzf mariadb-connector-odbc-*.tar.gz
    
  5. Change directory to the root directory of the extracted files.

    $ cd mariadb-connector-odbc-*
    
  6. Install the library:

    • On CentOS, RHEL, and Rocky Linux:

      $ sudo install lib/mariadb/libmaodbc.so /usr/lib64/
      $ sudo install -d /usr/lib64/mariadb/
      $ sudo install -d /usr/lib64/mariadb/plugin/
      $ sudo install lib64/mariadb/plugin/* /usr/lib64/mariadb/plugin/
      
    • On Debian / Ubuntu:

      $ sudo install lib/mariadb/libmaodbc.so /usr/lib/
      $ sudo install -d /usr/lib/mariadb/
      $ sudo install -d /usr/lib/mariadb/plugin/
      $ sudo install lib/mariadb/plugin/* /usr/lib/mariadb/plugin/
      
  7. Install a driver manager.

Windows (MSI)

MariaDB Connector/ODBC Windows Installer requires Windows 8 or newer operating system.

  1. Go to the MariaDB Connector/ODBC download page.

  2. In the "OS" dropdown, select "MS Windows 64-bit" or "MS Windows 32-bit," depending on whether you need a 64-bit or 32-bit library.

  3. Click the "Download" button to download the MSI package.

  4. Run the MSI package and click "Next" to start the Setup Wizard.

  5. On the second screen, click the license agreement checkbox, then click "Next."

  6. On the third screen, click "Typical."

  7. On the fourth screen, click "Install."

  8. Then, click "Finish."

macOS (PKG)

  1. Go to the MariaDB Connector/ODBC download page.

  2. In the "OS" dropdown, select "macOS."

  3. Click the "Download" button to download the PKG package.

  4. Run the PKG package to install.

  5. Install a driver manager.

Driver Managers

MariaDB Connector/ODBC requires a driver manager to provide the application interface for ODBC connections. The specific driver manager varies by operating system.

Operating System

Driver Manager

Requires Installation

Linux

unixODBC

Yes

Windows

ODBC Data Source Administrator

No

macOS

iODBC

Yes

Install unixODBC on CentOS / RHEL / Rocky Linux (via YUM)

  1. Install unixODBC using YUM:

    $ sudo yum install unixODBC
    

Install unixODBC on Debian / Ubuntu (via APT)

  1. Install unixODBC using APT:

    $ sudo apt update
    $ sudo apt install unixodbc
    

Install unixODBC on SLES (via ZYpp)

  1. Install unixODBC using ZYpp:

    $ sudo zypper install unixODBC
    

Install iODBC on macOS

  1. Go to iODBC.org:

    http://www.iodbc.org/dataspace/doc/iodbc/wiki/iodbcWiki/Downloads

  2. Download the disk image for iODBC.

  3. Install the disk image.