dyld: Library not loaded: /usr/local/opt/unixodbc/lib/libodbc.2.dylib

Asked 22/1, 2019 at 6:57 Answered 2/6, 2020 at 15:0

I am facing the following issue on Mac when I run rake ts:index for Thinking Sphinx indexing:

dyld: Library not loaded: /usr/local/opt/unixodbc/lib/libodbc.2.dylib

I am using mysql version 8.0.13 for osx10.13 on x86_64. How can I resolve this issue?

Pulverize answered 22/1, 2019 at 6:57 Comment(2)

What was the question? – Higgler 22/1, 2019 at 7:4

@Higgler Question was, how can this issue be resolved? The solution is written in the answer. – Pulverize 10/5, 2019 at 12:8

Insalling unixodbc on Mac resolved this for me.

brew install unixodbc

Pulverize answered 22/1, 2019 at 7:1 Comment(0)

In addition to

brew install unixodbc

you can also install the mssql drivers after this with the following brew instructions:

brew tap microsoft/mssql-release https://github.com/Microsoft/homebrew-mssql-release
brew update
brew install msodbcsql mssql-tools

After this I was able to use "ODBC Driver 17 for SQL Server" in python.

Mashburn answered 2/6, 2020 at 15:0 Comment(0)