The Mac OS X environment has a GUI interface for creating and configuring an IBM® Informix® ODBC data source name (DSN). This utility is the ODBC Administrator. To create and configure an Informix DSN on Mac OS X: Open the ODBC Administrator by choosing Applications Utilities ODBC Administrator. Click the System DSN tab. The Mac OS X environment has a GUI interface for creating and configuring an IBM® Informix® ODBC data source name (DSN). This utility is the ODBC Administrator. This utility is the ODBC Administrator.
- Odbc Administrator For Mac Free
- Odbc Administrator For Mac Pro
- Odbc Administrator For Mac 10
- Odbc Administrator For Mac Windows 7
- Odbc Administrator For Mac Windows 10
Active3 years ago
I have two applications in my Applications/Utilities folder that look exactly the same except for the icon. One is ODBC Manager, the other is ODBC Administrator.
![For For](/uploads/1/2/5/0/125011491/655976927.jpg)
Does anyone know what the difference between these two is?
John GallagherJohn Gallagher
2 Answers
ODBC Administrator was shipped with Mac OS X until 10.6 Snow Leopard, when it be came a separate download from the Apple support site.
Windows 7 sp1 update x64. ODBC Manager is an independently developed application that is functionally equivalent to the Apple ODBC Administrator. It is installed with the Actual ODBC Pack drivers from Actual Technologies (and potentially other 3rd party ODBC drivers).
If you are using 10.5 Leopard or earlier, or if you have installed Apple's Administrator from the support site, then you may have both administrators. You can use either one - Manager is intended to be equivalent (with some of Apple's bugs fixed).
Jonathan Monroe,Actual Technologies
user25643
In hopes of minimizing potential future confusion..
The comments from Jonathan Monroe (
user25643
) are generally correct, but incomplete.
You may additionally encounter the OpenLink ODBC Administrator.app (
/Applications/Utilities/
), also and originally known as the iODBC Administrator.app (/Applications/iODBC/
), which was the original ODBC administrator on Mac OS X (starting with Cheetah, 10.0.x) and has been updated for all OS X through El Capitan (10.11.x), before Apple produced their own ODBC Administrator.app (/Applications/Utilities/
) which they included in OS X Jaguar (10.2.x) through Snow Leopard (10.6.x).
The OpenLink ODBC Administrator.app is shipped as part of the iODBC SDK for Mac OS X and with all drivers from OpenLink Software (my employer), who maintains and supports the iODBC Project itself. Other driver vendors may also include this administrator and/or SDK in their installers.
Adobe creative suite 4 download. Find links and information for downloading Adobe Creative Suite 3 applications. Creative Suite. Learn & Support. The aging activation servers for Creative Suite 3 (CS3) applications had to be retired. Cloud-based storage, and free updates – at an amazingly low price. Receive a new serial number and installer Get a new serial number.
All of these administrators are linked to the same iODBC libraries ('dylibs') and/or Frameworks, and all settings should wind up in the same files (
/Library/ODBC/odbc.ini
, /Library/ODBC/odbcinst.ini
, ~/Library/ODBC/odbc.ini
, ~/Library/ODBC/odbcinst.ini
).
Odbc Administrator For Mac Free
Due to some bugs in older versions of iODBC and in various third-party installers, some other configuration files (most commonly and problematically,
~/.odbc.ini
and ~/.odbcinst.ini
; others include /etc/odbc.ini
, /etc/odbcinst.ini
, /etc/.odbc.ini
, /etc/.odbcinst.ini
) may exist on your Mac, and these may cause some trouble with various applications (e.g., System DSNs may not save at all, or may erroneously be seen in the User DSNs tab).
Recent versions of iODBC, 3.5.10 and later, will fix these issues automatically. If you encounter such issues and cannot update to 3.5.10 or later, the fix is to blend the content of these alternatively located files into the default files (in
~/Library/ODBC/
for user-level config, or in /Library/ODBC/
for system-level config), and replace each with a symlink to the appropriate default files (or simply remove the errant files and adjust any application configuration to target the default locations).
![Odbc administrator for mac windows 10 Odbc administrator for mac windows 10](/uploads/1/2/5/0/125011491/408354994.png)
OpenLink's Technical Support team can also assist with this cleanup, if needed. There is no cost for such assistance, if pursued through the web-based Case System.
TallTedTallTed
Odbc Administrator For Mac Pro
Not the answer you're looking for? Browse other questions tagged macosmacodbc or ask your own question.
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.
Odbc Administrator For Mac 10
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:
Odbc Administrator For Mac Windows 7
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 theadmin
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.
Odbc Administrator For Mac Windows 10
-
Open the ODBC Administrator from the
Utilities
folder in theApplications
folder.Figure 5.6ODBC 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 theData Source Name
and an optionalDescription
for the DSN.Figure 5.7ODBC 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
anddatabase
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”.