Odbc Administrator Tool For Mac Os X

The ODBC Driver for Mac OS X allows you to connect to the Teradata database from Mac OS Xapplications. To get started, see the README files. You can get community support for this download in the Connectivity forum. What is available on OS X? Starting with Mac OS X version 10.6 (Snow Leopard), ODBC Administrator is no longer shipped with the operating system and must be downloaded and installed separately: ODBC Administrator Tool for Mac OS X v1.0, or alternatively we can use ODBC Manager. Mac OS X comes with iODBC, installed in /usr/bin.

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:

Note: You must create this odbcinst.ini text file if it does not already exist.

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/kb/dl895

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.

To add a DSN using the 4D ODBC Driver:

1. Click on the System DSN tab
   Note: On Mac OS X, we recommend that you use a System DSN and not a User DSN.
2. Click the Add button and choose the 32-bit 4D ODBC Driver from the list of configured drivers:
   
3. Click OK.
   The 4D ODBC Driver’s own configuration panel appears:
   
4. Click OK to save any changes before you close the configuration panel window.

Note: You may encounter the following anomalies when creating a DSN via the Mac OS X ODBC Administrator:

• When you create a new DSN, you may not see it right away and may need to quit and restart the Mac OS X Administrator in order for it to appear.
• Even if you add a new ODBC User data source, the ODBC Driver will create it as a System DSN.
  These anomalies are both due to bugs in the Mac OS X ODBC Administrator and have nothing to do with the 4D ODBC Driver or Installer.

The fields of these dialog boxes need to be filled in with the following information:

• Data Source Name:
  Enter a unique name for this Data Source.
  Default: '.
  This field is mandatory.
• Description:
  Enter a short description of this Data Source.
  Default: '.
  This field is optional.
• Server Address:
  Examples:
  

  'localhost'	The 4D application is located on the local machine.
  'PC-1'	The 4D application is located on the PC-1 machine, published on port 19812 (default port).
  '148.1.2.3'	The 4D application has the IP address 148.1.2.3.

  
  Default: 'localhost'.
  This field is mandatory.
• Port:
  Enter the 4D access port.
  Default: '19812'.
  This field is optional.
• SSL checkbox:
  Checking this option enables connection to the 4D Server if the “Enable SSL” option has been set on the SQL/Configuration page of the Database Settings.
• User:
  Enter the user name used to test the connection with 4D.
  Default: '.
  This field is optional.
• Password:
  Enter the password used (in conjunction with the user name) to test the connection with 4D.
  Default: '.
  This field is optional.
• Test button
  Tests the connection with the current parameters.
  Uses “User Name” and “Password” fields to login.

Clicking on the Advanced >> button gives you access to additional options as shown here:

Timeouts (Seconds)

• Connection:
  Enter the timeout in seconds to be used (0 means no timeout) after you log in for the driver to connect to a socket on the server:port address.
  Default: '.
  This field is optional.
• Login:
  Enter the timeout in seconds to be used (0 means no timeout) when the driver sends a request and receives the status from the server.
  Default: '.
  This field is optional.
• Query:
  Enter the timeout in seconds to be used (0 means no timeout) when waiting for a response after a query to the server.
  Default: '.
  This field is optional.

Favorite image formats

Pictures stored in 4D databases are retrieved by ODBC as Blobs. This setting lets you select the formats you prefer. By default, if you do not choose any favorites, 4D selects the best format available with respect to screen display.

When you choose one or more formats, 4D only provides one of those formats (in order of preference). If there are no pictures available in any of your favorite formats, 4D converts the pictures to the first format in the list.

For example, if you have selected GIF and JPEG as your favorite image formats:

4D first checks whether there are any .gif or .jpeg formats available. If neither are available, then it converts the formats to .gif since it is first in the list.

Encoding: sets the text encoding.

• UTF-8 (Unicode) (recommended)
• System (depends on the settings of your OS)

Cache Settings: used to modify how the network handles the cache. Generally, these settings should be left untouched.

Compatibility: settings to enable the ODBC Driver to work properly with OpenQuery and MSAccess. They should only be checked if you encounter problems with these particular applications.

The 64-bit driver is faceless but there are two ways to create a 64-bit DSN:

• using the 32-bit driver, or
• using the ODBC Administrator.

Using the 32-bit driver

You can use the 32-bit ODBC driver to create a 32-bit DSN and then modify this DSN directly from the /Library/ODBC folder. Just open the /Library/ODBC/odbc.ini text file in a text editor and make the following edits:

1. In the [ODBC Data Sources] section: change '4D ODBC Driver 32-bit' to '4D ODBC Driver 64-bit'
2. In the [{your data source name}] section, change:
   Driver=/Library/ODBC/4D ODBC x32.bundle/Contents/MacOS/4D ODBC x32
   to:
   Driver=/Library/ODBC/4D ODBC x64.bundle/Contents/MacOS/4D ODBC x64

Using the ODBC Administrator or the iODBC Administrator

1. Click on the System DSN tab.
2. Click the Add button and choose the 64-bit 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:
   
4. Click OK
   The new DSN will then be available on the System DSN tab of your ODBC Administrator.

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:

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 the admin 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.

1. Open the ODBC Administrator from the Utilities folder in the Applications folder.

   Figure 5.6 ODBC Administrator Dialog

   
   

2. From the ODBC Administrator dialog, choose either the User DSN or System DSN tab and click .

3. Select the Connector/ODBC driver and click .

4. You will be presented with the Data Source Name (DSN) dialog. Enter the Data Source Name and an optional Description for the DSN.

   Figure 5.7 ODBC Administrator Data Source Name Dialog

   
   

5. Click to add a new keyword/value pair to the panel. Configure at least four pairs to specify the server, username, password and database connection parameters. See Section 5.2, “Connector/ODBC Connection Parameters”.

6. Click to add the DSN to the list of configured data source names.

A completed DSN configuration may look like this:

Figure 5.8 ODBC Administrator Sample DSN Dialog

You can configure other ODBC options in your DSN by adding further keyword/value pairs and setting the corresponding values. See Section 5.2, “Connector/ODBC Connection Parameters”.