Odbc For Mac

admin 12/13/2021

To configure a DSN on macOS, you can either use the command-line utility (myodbc-installer), edit the odbc.ini file within the Library/ODBC directory of the user, or use the ODBC Administrator GUI.

The ODBC Administrator is included in OS X v10.5 and earlier; users of later versions of OS X and macOS need to download and install it manually.

Odbc Driver For Mac

To create a DSN using the myodbc-installer utility, you only need to specify the DSN type and the DSN connection string. For example:

To use ODBC Administrator:

Mac install openssl
  • For correct operation of ODBC Administrator, ensure that the /Library/ODBC/odbc.ini file used to set up ODBC connectivity and DSNs are writable by the admin group. If this file is not writable by this group, then the ODBC Administrator may fail, or may appear to work but not generate the correct entry.

  • There are known issues with the macOS ODBC Administrator and Connector/ODBC that may prevent you from creating a DSN using this method. In that case, use the command line or edit the odbc.ini file directly. Existing DSNs or those that you created using the myodbc-installer tool can still be checked and edited using ODBC Administrator.

MySQL Connector/ODBC can be used as an ODBC database driver on multiple platforms, such as Mac OS X, Windows and Linux. By installing the MySQL Connector/ODBC driver you will be able to connect to any MySQL databases using the ODBC interface. Devart ODBC Drivers provide high-performance and feature-rich connectivity solutions for ODBC-compliant applications to access the most popular databases directly from Windows, macOS, and Linux, both 32-bit and 64-bit. Drivers fully support standard ODBC API functions and data types, multiple server data types and features. Download ODBC Manager 1.0.19. 840 KB 64-bit only. Requires Mac OS 10.9 or later. Made for 64-bit ODBC drivers. Notarized and Gatekeeper compatible.

  1. Open the ODBC Administrator from the Utilities folder in the Applications folder.

    Figure 5.6 ODBC Administrator Dialog


  2. From the ODBC Administrator dialog, choose either the User DSN or System DSN tab and click .

  3. Select the Connector/ODBC driver and click .

  4. You will be presented with the Data Source Name (DSN) dialog. Enter the Data Source Name and an optional Description for the DSN.

    Figure 5.7 ODBC Administrator Data Source Name Dialog


  5. Click to add a new keyword/value pair to the panel. Configure at least four pairs to specify the server, username, password and database connection parameters. See Section 5.2, “Connector/ODBC Connection Parameters”.

  6. Click to add the DSN to the list of configured data source names.

A completed DSN configuration may look like this:

Odbc For Mac

Figure 5.8 ODBC Administrator Sample DSN Dialog


You can configure other ODBC options in your DSN by adding further keyword/value pairs and setting the corresponding values. See Section 5.2, “Connector/ODBC Connection Parameters”.

macOS is based on the FreeBSD operating system, and you can normally use the MySQL network port for connecting to MySQL servers on other hosts. Installing the Connector/ODBC driver lets you connect to MySQL databases on any platform through the ODBC interface. If your application requires an ODBC interface, install the Connector/ODBC driver.

On macOS, the ODBC Administrator, based on the iODBC manager, provides easy administration of ODBC drivers and configuration, allowing the updates of the underlying iODBC configuration files through a GUI tool. The tool is included in macOS v10.5 and earlier; users of later versions of macOS need to download it from http://www.iodbc.org/dataspace/doc/iodbc/wiki/iodbcWiki/Downloads and install it manually.

Odbc Driver For Mac Excel 2011 Free

OpenSSL is a required dependency. The macOS installation binaries bundle OpenSSL, while the compressed tar archives do not and require that you install OpenSSL on your system before the installation process.

There are two ways to install Connector/ODBC on macOS. You can use either the package provided in a compressed tar archive that you manually install, or use a compressed disk image (.dmg) file, which includes an installer.

To install using the compressed tar archive (some of the steps below might require superuser privileges):

  1. Download the compressed tar archive.

  2. Extract the archive:

  3. The directory created contains two subdirectories, lib and bin. Copy these to a suitable location such as /usr/local:

  4. Finally, register the driver with iODBC using the myodbc-installer tool that was included in the package:

    For Connector/ODBC 8.0:

    For Connector/ODBC 5.3:

Odbc for mac

To install using the a compressed disk image (.dmg) file:

iODBC 3.52.12 or later must be installed on the macOS system before you can install Connector/ODBC using a compressed disk image. See Section 4.3, “Installing Connector/ODBC on macOS”.

For
  1. Download the disk image.

  2. Double click the disk image to open it. You see the Connector/ODBC installer inside.

  3. Double click the Connector/ODBC installer, and you will be guided through the rest of the installation process. You need superuser privileges to finish the installation.

Odbc manager for mac

To verify the installed drivers, either use the ODBC Administrator application or the myodbc-installer utility: