Installing the ODBC Driver on Mac OS X
You can obtain the Vertica ODBC driver for Mac OS X as a .pkg file through the myVertica portal. You can run the installer as a regular Mac OS X installer or silently. This driver is compatible with both 32-bit and 64-bit applications.
The installer is designed to be used with the standard iODBC Driver Manager included in Mac OS X. While Mac OS X ships with the iODBC Driver Manager already installed, you may choose to download the most recent version of the driver at the iODBC.org website.
By default, the installer installs the driver in the following location: /Library/Vertica/ODBC/lib/libverticaodbc.dylib. The installer also automatically registers a driver named "Vertica" with the iODBC Driver Manager.
To use the unixODBC Driver Manager instead of Apple's iODBC Driver Manager, see the unixODBC.org website.
Before You Download the Driver
If you installed a previous version of the Vertica ODBC driver for Mac OS X, your system may already have a registered driver named "Vertica." In this case, If you must remove or rename the older version of the driver before installing the Vertica ODBC driver .pkg.
To have multiple versions of the driver installed on your system at the same time, you must rename the currently installed version of the driver to something other than "Vertica." You can do so using the Apple ODBC Administrator Tool.
To rename the driver:
-
Using your web browser, download and install the Apple ODBC Administrator Tool.
-
Locate and open the ODBC Administrator Tool after installation:
- Navigate to Finder > Applications > Utilities.
- Open the ODBC Administrator Tool.
-
Click the Drivers tab, and then select the driver named "Vertica."
-
Click the Configure button. A dialog box opens.
- In Description, enter a new name for the driver, and then click OK. The dialog box closes.
- On the ODBC Administrator page, click Apply.
-
Exit the ODBC Administrator Tool.