The ODBC Driver for Mac OS X allows you to connect to the Teradata database from Mac OS Xapplications. TTU Windows Package This Teradata Tools and Utilities (TTU. OpenLink Software provides a separate iODBC SDK product installer for Mac Classic and Mac OS X platforms. These installers contain the sql.h, sqlext.h, and sqltypes.h header files. Developers may use these files to build ODBC-compliant applications.

Odbc Administrator Tool For Mac Os X 10.10
Odbc Administrator Tool For Mac Os X 10.8
Odbc Administrator Tool For Mac Os X

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.

Open the ODBC Administrator from the Utilities folder in the Applications folder.
Figure 5.6 ODBC Administrator Dialog
From the ODBC Administrator dialog, choose either the User DSN or System DSN tab and click .
Select the Connector/ODBC driver and click .
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
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”.
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”.

ODBC Administrator
Stable release
Developer(s)	Apple Computer
Operating system	Mac OS X
Type	Database utility
License	Proprietary
Website	https://support.apple.com/kb/dl895

ODBC Administrator is a 32-bit utility in the Mac OS Xoperating system for administering ODBC, which enables interaction with ODBC-compliant data sources. Features include connection pooling, trace log creation, and ODBC driver management, among other administration features.

Although Apple started including the underlying iODBC libraries in Mac OS X 'Jaguar' (10.2.x),^[1] and has continued to do so through at least macOS High Sierra (10.13.x),^[2] Apple only included their ODBC Administrator through Mac OS X 'Leopard' (10.5.x), and temporarily made it available as a separate download (since removed) for Mac OS X 'Snow Leopard' (10.6.x).

Alternatives to Apple's 32-bit ODBC Administrator include the free and open source 32-bit and 64-bit iODBC Administrator included with the iODBC SDK, which is available for all extant versions of Mac OS X (10.0.x through 10.13.x).^[3]

References[edit]

Odbc Administrator Tool For Mac Os X 10.10

^Open Source Software in Mac OS X Jaguar (10.2.1)
^Open Source Software in macOS High Sierra (10.13.0)
^iODBC SDK Downloads

Odbc Administrator Tool For Mac Os X 10.8

Odbc Administrator Tool For Mac Os X

Retrieved from 'https://en.wikipedia.org/w/index.php?title=ODBC_Administrator&oldid=880487439'

2021.09