

Output of file /usr/local/mysql-connector-odbc-5.3.10-macos10.13-x86-64bit/lib/*.so is likely to be revealing. One current question is the libmyodbc5w.so. Randomly moving library files around is not usually recommended please put the libraries you moved from /usr/local/mysql-connector-odbc-5.3.10-macos10.13-x86-64bit/lib to ~ back in their originally installed location. (Free two-week trial license is provided with download.)
ODBC MANAGER MAC SIERRA DRIVERS
This can easily be confirmed by downloading and testing with any of our own ODBC Drivers for MySQL the Lite Edition provides easiest setup with optimal compatibility with all 32-bit and 64-bit ODBC applications.

I think your issue is with the mysql-connector ODBC driver, not with the iODBC driver manager. The iODBC libraries are "fat" binaries containing both 32-bit and 64-bit, and only the 64-bit portion of the iODBC libraries is loaded when the 64-bit Excel 16.10 (or iODBC Administrator64.app, or any other 64-bit app) calls. have a look at where we'd be delighted to sell you a 32-bit driver.Įxcel 2016 v16.10 is definitely 64-bit only.compile your own 32-bit ODBC Connector, or.
ODBC MANAGER MAC SIERRA UPDATE
see if you can update Excel to a 64-bit version - see.My betting is if you were to run file on Excel 2016, you'd find it was 32-bit. This shows our iODBC Administrator 64-bit supports both 32- and 64-bit architectures for the 32-bit version the same command only shows an i386 architecture. Applications/iODBC/iODBC Administrator64.app/Contents/MacOS/iODBC Administrator64 (for architecture i386): Mach-O executable i386 Applications/iODBC/iODBC Administrator64.app/Contents/MacOS/iODBC Administrator64 (for architecture x86_64): Mach-O 64-bit executable x86_64
ODBC MANAGER MAC SIERRA 64 BIT
So always use 64 bit drivers with 64 bit Data Modeler and 32 bit drivers with 32 bit Data Modeler./Applications/iODBC/iODBC Administrator64.app/Contents/MacOS/iODBC Administrator64: Mach-O universal binary with 2 architectures: Also make sure that whatever bit level is used for your ODBC driver, be sure to use the same matching bit level for Data Modeler. To manage a data source that connects to a 64-bit driver, use c:\windows\system32\odbcad32.exe. To manage a data source that connects to a 32-bit driver under a 64-bit platform, use c:\windows\sysWOW64\odbcad32.exe.

This error can also occur if you use the wrong version of ODBC Administrator to try to configure an ODBC driver that does not have the same bit level. So for example, if the ODBC drivers are 32 bit and erwin Data Modeler is 64 bit, or vice versa.

This error can occur if the ODBC driver you are using does not match the bit level of erwin Data Modeler. Even though ODBC connection test tests successfully in ODBC Data Source Administrator. The specified DSN contains an architecture mismatch between the Driver and ApplicationĮrror appears when attempting to connect to an ODBC data source. Storage Performance and Utilization Management.Information Archiving & Storage Management.Hybrid Active Directory Security and Governance.Starling Identity Analytics & Risk Intelligence.One Identity Safeguard for Privileged Passwords.
