. Trevor Hodges 2005/08/23 10:56 AM -0700 wrote: I am using OSX 10.2.8, and took the following steps to try and get the ODBC connection working: 1) I configured the System Data Source 'FMP' using the ODBC Administrator tool included with the OS, and a driver file for FileMaker Pro ODBC. Like ODBC on the Windows platform, iODBC comprises the following: Runtime resources ODBC Drivers - Simply, Drivers that implement the ODBC API. IODBC Driver Manager - The Driver Manager is implemented as a Framework under Mac OS X; and a Shared Library under Darwin, Linux, UNIX and OpenVMS. IODBC Administrator - iODBC provides the native GUI.
Install the Drill ODBC Driver on the machine from which you connect tothe Drill service.
Install the Drill ODBC Driver on a system that meets the system requirements. Complete the following steps, described in detail in this document:
- Step 1: Download the Drill ODBC Driver
- Step 3: Check the Drill ODBC Driver Version
System Requirements
To install the driver, you need Administrator privileges on the computer.
- Mac OS X version 10.9, 10.10, or 10.11
- 100 MB of available disk space
- iODBC 3.52.7 or later
The iodbc-config file in the/usr/local/iODBC/bin
includes the version of the driver. The client must be able to resolve the actual host name of the Drill node or nodes from the IP address. Verify that a DNS entry was created on the client machine for the Drill node or nodes. If not, create an entry in
/etc/hosts
for each node in the following format:<drill-machine-IP> <drill-machine-hostname>
.Example:
127.0.0.1 localhost
Step 1: Download the Drill ODBC Driver
To download ODBC drivers that support both 32- and 64-bit client applications, click Drill ODBC Driver for Mac.
Step 2: Install the Drill ODBC Driver
To install the driver, complete the following steps:
- Double-click
MapR Drill 1.3.dmg
to mount the disk image. - Double-click
MapRDrillODBC.pkg
to run the Installer. - Follow the instructions in the Installer to complete the installation process.
- When the installation completes, click Close.
Drill ODBC Driver files install in the following locations:
/Library/mapr/drill/ErrorMessages
– Error messages files directory/Library/mapr/drill/Setup
– Sample configuration files directory/Library/mapr/drill/lib
– Binaries directory
Step 3: Check the Drill ODBC Driver Version
To check the version of the driver you installed, use the following command on the terminal command line:
To display information about the iODBC driver manager installed on the machine, issue the following command:
Next Step
Configuring ODBC on Mac OS X.
Iodbc Driver Manager For Mac Os X El Capitan
ODBC Manager is a Mac OS utility application that configures ODBC data sources for use by popular applications such as Microsoft Excel and FileMaker Pro.
Mac OS used to include an ODBC Administrator utilty. Apple stopped including the ODBC Administrator with Mac OS starting with the release of Mac OS X 'Snow Leopard'.
ODBC Manager was developed as a replacement for ODBC Administrator. It is intended to be distributed easily. You are free to include ODBC Manager with your application.
ODBC driver vendors are encouraged to include ODBC Manager with their drivers.
ODBC Manager was developed and is maintained by Actual Technologies, makers of ODBC drivers for many popular databases.
Horizon For Mac
Download ODBC Manager 1.0.19
Iodbc Driver Manager For Mac Os X 10 11
840 KB | 64-bit only
Requires Mac OS 10.9 or later
Made for 64-bit ODBC drivers
Manager For Mac Accounting Software
Notarized and Gatekeeper compatible