Thanks Bogdan
I found that www.actualtech.com<http://www.actualtech.com> works for my configuration.
Until you solve the problem below, I strongly recommend that you withdraw mysql-connector-odbc-5.3.6-osx10.10-x86-64bit from distribution or, at the very least, include your information below in mysql-connector-odbc-5.3.6-osx10.10-x86-64bit/INSTALL and mysql-connector-odbc-5.3.6-osx10.10-x86-64bit/README so that other users do not waste their time trying to use a version of Connector/ODBC 5.3.6 for OS X that does not work as I have done.
Regards
Arthur
On Nov 23, 2016, at 4:12 AM, Bogdan Degtyariov <bogdan.degtyariov@stripped<mailto:bogdan.degtyariov@strippedm>> wrote:
On 23/11/2016 7:25 AM, Goldberg, Arthur P wrote:
Hi
Since writing the below I’ve attempted to use Mac OS X 10.10 (x86, 64-bit), Compressed TAR Archive<https://urldefense.proofpoint.com/v2/url?u=http-3A__dev.mysql.com_downloads_connector_odbc_&d=AwIDaQ&c=4R1YgkJNMyVWjMjneTwN5tJRn8m8VqTSNCjYLg1wNX4&r=TntoeYH7lekXzpBRjXwLTkqiWTbWAvp3pHKo_kZp5qI&m=g2g4dLuIQUx3Xe0Sfz89xGQDuwb0t4tdjnz_3r0WiUM&s=IbXsdQDwJeh8Saq_rjm8MSQau50XinftuRfyeZHgi9c&e= >. Following the directions at https://urldefense.proofpoint.com/v2/url?u=https-3A__dev.mysql.com_doc_connector-2Dodbc_en_connector-2Dodbc-2Dinstallation-2Dbinary-2Dosx.html&d=AwIDaQ&c=4R1YgkJNMyVWjMjneTwN5tJRn8m8VqTSNCjYLg1wNX4&r=TntoeYH7lekXzpBRjXwLTkqiWTbWAvp3pHKo_kZp5qI&m=g2g4dLuIQUx3Xe0Sfz89xGQDuwb0t4tdjnz_3r0WiUM&s=k1Dvv51TEIBJSubXsdMWVHuzBJk14vzj3Ai5ypblZ_g&e= , I get
$ ls -l /usr/local/lib
total 19480
-rwxr-xr-x@ 1 root wheel 4988284 Nov 21 22:08 libmyodbc5a.so
-rwxr-xr-x@ 1 root wheel 4984300 Nov 21 22:08 libmyodbc5w.so
$ /usr/local/bin/myodbc-installer
dyld: Library not loaded: /Volumes/hd2/pb2/build/sb_0-18231254-1457622765.94/unixODBC-2.3.2-osx10.10-x86-64bit/lib/libodbc.2.dylib
Referenced from: /usr/local/bin/myodbc-installer
Reason: image not found
Trace/BPT trap: 5
Examining myodbc-installer further, it uses the following dylibs:
$ otool -L /usr/local/bin/myodbc-installer
/usr/local/bin/myodbc-installer:
/Volumes/hd2/pb2/build/sb_0-18231254-1457622765.94/unixODBC-2.3.2-osx10.10-x86-64bit/lib/libodbc.2.dylib (compatibility version 3.0.0, current version 3.0.0)
/Volumes/hd2/pb2/build/sb_0-18231254-1457622765.94/unixODBC-2.3.2-osx10.10-x86-64bit/lib/libodbcinst.2.dylib (compatibility version 3.0.0, current version 3.0.0)
/usr/lib/libz.1.dylib (compatibility version 1.0.0, current version 1.2.5)
/usr/lib/libSystem.B.dylib (compatibility version 1.0.0, current version 1197.1.1)
/usr/lib/libc++.1.dylib (compatibility version 1.0.0, current version 120.0.0)
This appears to use a dylibs that are not available in the ODBC connector tarball (libodbc.2.dylib, and libodbcinst.2.dylib). Perhaps they map to the dylibs in the tarball, but how is not clear.
On Nov 21, 2016, at 9:38 PM, Arthur Goldberg <arthur.p.goldberg@stripped<mailto:arthur.p.goldberg@mssm.edu><mailto:arthur.p.goldberg@stripped>> wrote:
Hi
I use a Mac running OS X Yosemite 10.10.
I’ve downloaded "Mac OS X 10.10 (x86, 64-bit), DMG Archive” from https://urldefense.proofpoint.com/v2/url?u=https-3A__dev.mysql.com_downloads_connector_odbc_5.2.html&d=AwIDaQ&c=4R1YgkJNMyVWjMjneTwN5tJRn8m8VqTSNCjYLg1wNX4&r=TntoeYH7lekXzpBRjXwLTkqiWTbWAvp3pHKo_kZp5qI&m=g2g4dLuIQUx3Xe0Sfz89xGQDuwb0t4tdjnz_3r0WiUM&s=gzfoPAjgpASoVyfjqZHE1kk_z5B0vqL_E91AMc4eyJM&e= , verified its MD5 (42770b6703771204c1fe46e15b9aa347), and attempted to install the archive. Repeatedly, I receive the error “The Installation failed”. See https://urldefense.proofpoint.com/v2/url?u=https-3A__www.dropbox.com_s_cilcuzd00vz4jpk_InstallationFailed2.jpg-3Fdl-3D0&d=AwIDaQ&c=4R1YgkJNMyVWjMjneTwN5tJRn8m8VqTSNCjYLg1wNX4&r=TntoeYH7lekXzpBRjXwLTkqiWTbWAvp3pHKo_kZp5qI&m=g2g4dLuIQUx3Xe0Sfz89xGQDuwb0t4tdjnz_3r0WiUM&s=1UfNxbzprvU9V2Clr1g0vreOZ7eVMpXLgXei_g35clo&e= . The installation appears to fail just after the ‘package validation’ phase starts.
Rebooting the Mac does not help.
Is there another ODBC driver that’s likely to connect Excel with MySQL on my Mac? Or can this be fixed?
Thanks
Arthur
Arthur Goldberg, PhD
Associate Professor of Genetics and Genomic Sciences
Icahn Institute for Genomics & Multiscale Biology
Icahn School of Medicine at Mount Sinai
646 526 5020
Karr Lab<https://urldefense.proofpoint.com/v2/url?u=http-3A__www.karrlab.org_&d=AwIDaQ&c=4R1YgkJNMyVWjMjneTwN5tJRn8m8VqTSNCjYLg1wNX4&r=TntoeYH7lekXzpBRjXwLTkqiWTbWAvp3pHKo_kZp5qI&m=g2g4dLuIQUx3Xe0Sfz89xGQDuwb0t4tdjnz_3r0WiUM&s=tUcmaMN6p-W_3f6kE1WGY2SLDJh_fUqbH0SBO8MkhGg&e= >
Arthur.P.Goldberg@stripped<mailto:Arthur.P.Goldberg@stripped><mailto:Arthur.Goldberg@stripped>
Follow us on Twitter @IcahnInstitute<https://urldefense.proofpoint.com/v2/url?u=https-3A__twitter.com_IcahnInstitute&d=AwIDaQ&c=4R1YgkJNMyVWjMjneTwN5tJRn8m8VqTSNCjYLg1wNX4&r=TntoeYH7lekXzpBRjXwLTkqiWTbWAvp3pHKo_kZp5qI&m=g2g4dLuIQUx3Xe0Sfz89xGQDuwb0t4tdjnz_3r0WiUM&s=-dynhZ_lBYateOVrdaf0BF6Erb10r46M_A4EqcW78WA&e= >
Arthur Goldberg, PhD
Associate Professor of Genetics and Genomic Sciences
Icahn Institute for Genomics & Multiscale Biology
Icahn School of Medicine at Mount Sinai
646 526 5020
Karr Lab<https://urldefense.proofpoint.com/v2/url?u=http-3A__www.karrlab.org_&d=AwIDaQ&c=4R1YgkJNMyVWjMjneTwN5tJRn8m8VqTSNCjYLg1wNX4&r=TntoeYH7lekXzpBRjXwLTkqiWTbWAvp3pHKo_kZp5qI&m=g2g4dLuIQUx3Xe0Sfz89xGQDuwb0t4tdjnz_3r0WiUM&s=tUcmaMN6p-W_3f6kE1WGY2SLDJh_fUqbH0SBO8MkhGg&e= >
Arthur.P.Goldberg@stripped<mailto:Arthur.P.Goldberg@stripped><mailto:Arthur.Goldberg@mssm.edu>
Follow us on Twitter @IcahnInstitute<https://urldefense.proofpoint.com/v2/url?u=https-3A__twitter.com_IcahnInstitute&d=AwIDaQ&c=4R1YgkJNMyVWjMjneTwN5tJRn8m8VqTSNCjYLg1wNX4&r=TntoeYH7lekXzpBRjXwLTkqiWTbWAvp3pHKo_kZp5qI&m=g2g4dLuIQUx3Xe0Sfz89xGQDuwb0t4tdjnz_3r0WiUM&s=-dynhZ_lBYateOVrdaf0BF6Erb10r46M_A4EqcW78WA&e= >
Hi Arthur,
Thanks for your interest in MySQL software.
We are aware of the problem you described.
The Connector/ODBC 5.3.6 for OSX needs UnixODBC to work.
The problem with UnixODBC is that there is no official binary distribution for OSX.
The immediate solution of the MySQL Connector/ODBC issue you are experiencing is building UnixODBC from sources (https://urldefense.proofpoint.com/v2/url?u=http-3A__www.unixodbc.org_&d=AwIDaQ&c=4R1YgkJNMyVWjMjneTwN5tJRn8m8VqTSNCjYLg1wNX4&r=TntoeYH7lekXzpBRjXwLTkqiWTbWAvp3pHKo_kZp5qI&m=g2g4dLuIQUx3Xe0Sfz89xGQDuwb0t4tdjnz_3r0WiUM&s=N87IBiAbTpFHLwzJUN0lLTdC5o7Hy3HChgMEIytqMBM&e= )
In the upcoming release of Connector/ODBC 5.3.7 this issue should be resolved. Unfortunately, I cannot disclose the date of the release prior to the official announcement.
Thanks for your patience.
--
Best Regards,
Bogdan Degtyariov
Arthur Goldberg, PhD
Associate Professor of Genetics and Genomic Sciences
Icahn Institute for Genomics & Multiscale Biology
Icahn School of Medicine at Mount Sinai
646 526 5020
Karr Lab<http://www.karrlab.org/>
Arthur.P.Goldberg@stripped<mailto:Arthur.Goldberg@stripped>
Follow us on Twitter @IcahnInstitute<https://twitter.com/IcahnInstitute>