Installing an ODBC Driver on OS X

To install the ODBC Driver:

1. Copy the 4D ODBC x64.bundle and/or the 4D ODBC x32.bundle into the {Library}/ODBC/ folder
   
2. Open the odbcinst.ini text file found in the /Library/ODBC/ folder with a text editor and modify it as follows:

You can now launch the ODBC Manager located in the "Applications/Utilities/" folder in order to create a Data Source Name (DSN) or you can use the one provided with the iODBC framework.

Note: Since Mac OS X 10.6 Snow Leopard, the ODBC Administration Tool is no longer provided as standard. However, it can be downloaded from here:
http://support.apple.com/downloads/ODBC_Administrator_Tool_for_Mac_OS_X

By clicking on the "Drivers” tab, you can check that the 4D ODBC Driver is correctly installed:

This window provides you with the complete path name for each driver installed.

You can do the same with the iODBC Administrator:

Here you can also see the version number but only for 32-bit versions. 

Note: Beginning with version 14R2, version numbers include the subversion and modification date in the form: <Version><Subversion><Year><Month+Day>
For example: "14.2.2014.0217", this indicates the 14R2 version modified on February 17, 2014.

The ODBC driver is faceless.

1. Click on the System DSN tab.
2. Click the Add button and choose the 4D ODBC Driver from the list of configured drivers. The generic DSN generator appears.
3. Fill in the following Keyword/Value pairs in the dialog:
   

   Keyword	Value
   Driver	/Library/ODBC/4D ODBC x64.bundle/Contents/MacOS/4D ODBC x64
   Server	<IP address of 4D Server>
   UID	<User's name>
   PWD	<User's password (can be left blank)>

   
   
   
   Here is the equivalent for iODBC:
   
   For more information about keywords, please refer to the Keywords section.
4. Click OK
   The new DSN will then be available on the System DSN tab of your ODBC Administrator.