ODBC Administrator does not display per-user configuration information on Mac OS X v10.6
Problem Description
The version of iodbc
shipped on OS X was upgraded to 2.52.6 in Mac OS X v10.6. The new version expects to find user-specific configuration information at ~/.odbc.ini
and ~/.odbcinst.ini
instead of ~/Library/ODBC/odbc.ini
and ~/Library/ODBC/odbcinst.ini
where previous versions placed it.
There are two issues that result from this change:
iodbc
does not find existing configuration information, and may not find newly-created configuration information created by the ODBC Administrator tool.ODBC Administrator (downloadable from http://support.apple.com/) does not find existing configuration information, and may not find newly-created configuration information.
Workaround
To work around the problem, you can create a symbolic link between each pair of locations in one of the following two ways.
For existing users who have already configured user DSNs
While logged in as the existing user, launch Terminal.
In Terminal, enter the following commands :
ln -s Library/ODBC/odbc.ini .odbc.ini |
ln -s Library/ODBC/odbcinst.ini .odbcinst.ini |
For new users who do not yet have configured user DSNs
While logged in as the new user, launch Terminal.
In Terminal, enter the following commands :
mkdir -p Library/ODBC |
touch Library/ODBC/odbc.ini |
touch Library/ODBC/odbcinst.ini |
ln -s Library/ODBC/odbc.ini .odbc.ini |
ln -s Library/ODBC/odbcinst.ini .odbcinst.ini |
Copyright © 2009 Apple Inc. All Rights Reserved. Terms of Use | Privacy Policy | Updated: 2009-09-02