Menu
Mac OS X client access to Microsoft SQL Server, MySQL, Oracle, PostgreSQL, and Sybase Support for all network protocols and server operating environments, which are supported by the database vendors' communications products. I'm trying to install this mysql odbc connector on my macOS High Sierra machine, but I get this error: I tried installing it using installer in the hopes of getting information about what went wro.
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.
- This article walks through creating a DSN for MySQL data in iODBC and accessing MySQL data in Microsoft Excel, all on a machine running Mac OS X. Installing the CData ODBC Drivers on Mac OS X. The CData ODBC Driver for MySQL is preconfigured for the iODBC driver manager, as are many other products like Microsoft Excel.
- 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.
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. ![Mysql Mysql](/uploads/1/2/6/3/126301259/112377668.jpg)
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):
- Download the compressed tar archive.
- Extract the archive:
- The directory created contains two subdirectories,
lib
andbin
. Copy these to a suitable location such as/usr/local
: - 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:
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 5.4.3, “Installing Connector/ODBC on macOS”.
- Download the disk image.
- Double click the disk image to open it. You see the Connector/ODBC installer inside.
- 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.
To verify the installed drivers, either use the ODBC Administrator application or the myodbc-installer utility:
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.
To create a DSN using the myodbc-installer utility, you only need to specify the DSN type and the DSN connection string. For example:
Odbc Mysql Mac Os X
To use ODBC Administrator:
- 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 theadmin
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.
- Open the ODBC Administrator from the
Utilities
folder in theApplications
folder.Figure 5.7ODBC Administrator
Dialog - From the
ODBC Administrator
dialog, choose either the User DSN or System DSN tab and click . - Select the Connector/ODBC driver and click .
- You will be presented with the
Data Source Name
(DSN) dialog. Enter theData Source Name
and an optionalDescription
for the DSN.Figure 5.8ODBC Administrator Data Source Name
Dialog - Click to add a new keyword/value pair to the panel. Configure at least four pairs to specify the
server
,username
,password
anddatabase
connection parameters. See Section 5.5.2, “Connector/ODBC Connection Parameters”. - Click to add the DSN to the list of configured data source names.
Mysql Odbc Driver For Mac
A completed DSN configuration may look like this:
Figure 5.9
ODBC Administrator Sample DSN
DialogMysql-connector-odbc Download For Mac
You can configure other ODBC options in your DSN by adding further keyword/value pairs and setting the corresponding values. See Section 5.5.2, “Connector/ODBC Connection Parameters”.