22.1.3.3. Installing Connector/ODBCon Mac OS X

Mac OS X 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. Applications that require or can use ODBC (and therefore the Connector/ODBC driver) include ColdFusion, Filemaker Pro, 4th Dimension and many other applications.

Mac OS X includes its own ODBC manager, based on the iODBC manager. Mac OS X includes an administration tool that provides easier administration of ODBC drivers and configuration, updating the underlying iODBC configuration files.

For Connector/ODBC 5.x, the package is provided as a compressed tar archive that you manually install.

In either case, the driver is designed to work with the iODBC driver manager included with Mac OS X.

To install Connector/ODBC 5.x:

Download the installation file for the appropriate level of Mac OS X (10.5 or higher).

Extract the archive:

shell> tar xvzf mysql-connector-odbc-5.x.y-osx10.z-x86-(32|64)bit.tar.gz

The directory created contains the subdirectories, lib, bin, and test. Copy the contents of lib and bin to a suitable location such as /usr/local:
```
shell> sudo cp bin/* /usr/local/binshell> sudo cp lib/* /usr/local/lib
```

Finally, register the driver with iODBC using the myodbc3i tool you just installed:

shell> myodbc3i -a -d -t"MySQL ODBC 3.51 Driver;Driver=/usr/local/lib/libmyodbc3.so;Setup=/usr/local/lib/libmyodbc3S.so"

To verify the installed drivers, either use the ODBC Administrator application or the myodbc3i utility:

shell> myodbc3i -q -d