Menu
▾
▴
Re: [Iodbc-macosx] Switch to brew libiodbc
|
From: Ted T. Jr <tth...@op...> - 2019-01-03 22:36:39
|
On Jan 2, 2019, at 09:28 PM, Andrew Freedman via Iodbc-macosx <iod...@li...> wrote: > > My ask: how do I completely remove iODBC? > > The background: > > I installed from the latest version on www.iodbc.org (mxkozzzz.dmg) and ran into an error message when trying to add a DSN: "An error occurred when trying to add the DSN : request failed”. > > Turns out I didn’t really need to set up a DSN – the application/driver combo I was using (Tableau + Amazon EMR) were happy enough without one. > > Since the front end of iODBC Administrator isn’t working for me I figured I’d switch to the homebrew formula for libiodbc instead. Presumably this achieves the same effect as the iODBC package? So, yeah, as above – I want to scrub off whatever the installer added so that once I install libiodbc there’s no peculiar duplication. > > Thanks, > > Andrew Note that you should not "completely remove" iODBC from your Mac, as some iODBC libraries are shipped as part of the default macOS (have been since 10.3.0, and this is confirmed through 10.14.x) -- https://opensource.apple.com/release/macos-10141.html Users will generally be far better off sticking with the prebuilt iODBC SDK (which is more recent and more complete than Apple's bundled libraries, as the SDK includes prebuilt Frameworks, the iODBC Administrator apps, and several sample tools) downloaded via iodbc.org -- http://www.iodbc.org/wiki/iodbcWiki/Downloads#Mac%20OS%20X -- which currently delivers this installer -- http://download3.openlinksw.com/uda/components/7.0/universal-apple-macosx10.7-32/mxkozzzz.dmg (Note -- OpenLink Software maintains and supports iODBC, as we have since its creation.) When necessary, point environment variables and/or application settings to load these (which will happen automagically for all tools bound to the iODBC Frameworks -- which are not installed via brew -- such as Microsoft Office, and for most tools that point to /usr/lib/...), and to use the default settings files as found on macOS, i.e. -- /Library/ODBC/odbc.ini /Library/ODBC/odbcinst.ini ~/Library/ODBC/odbc.ini ~/Library/ODBC/odbcinst.ini ~/.odbc.ini -> ~/Library/ODBC/odbc.ini ~/.odbcinst.ini -> ~/Library/ODBC/odbcinst.ini The first two are System-level; the latter four are User-level. Note -- the last two symlinks should not use the shortcuts shown above, but use the fully-qualified and absolute paths on your system, e.g. -- /Users/johndoe/Library/ODBC/odbc.ini /Users/johndoe/Library/ODBC/odbcinst.ini /Users/johndoe/.odbc.ini -> /Users/johndoe/Library/ODBC/odbc.ini /Users/johndoe/.odbcinst.ini -> /Users/johndoe/Library/ODBC/odbcinst.ini DSN setup is generally best done through the iODBC Administrator.app (or the iODBC Administrator64.app, if working with a 64-bit ODBC driver with a 64-bit Setup library). Many third-party apps do not "do the right thing" for DSN setup, but work fine with DSNs that are set up through the iODBC apps. If there are consistent issues with setting up DSNs for any driver through the iODBC apps, we would very much like to know about them, so we can work with the driver vendor to resolve them! I hope that's helpful. Ted -- A: Yes. http://www.idallen.com/topposting.html | Q: Are you sure? | | A: Because it reverses the logical flow of conversation. | | | Q: Why is top posting frowned upon? Ted Thibodeau, Jr. // voice +1-781-273-0900 x32 Senior Support & Evangelism // mailto:tth...@op... // http://twitter.com/TallTed OpenLink Software, Inc. // http://www.openlinksw.com/ 20 Burlington Mall Road, Suite 322, Burlington MA 01803 Weblog -- http://www.openlinksw.com/blogs/ Community -- https://community.openlinksw.com/ LinkedIn -- http://www.linkedin.com/company/openlink-software/ Twitter -- http://twitter.com/OpenLink Google+ -- http://plus.google.com/100570109519069333827/ Facebook -- http://www.facebook.com/OpenLinkSoftware Universal Data Access, Integration, and Management Technology Providers |
