odbcinst: SQLRemoveDriver failed with Unable to find component name. about homebrew-mssql-release HOT 10 CLOSED

Are you using an ARM Mac? Have you seen #51 and other related issues here?

from homebrew-mssql-release.

Thank you for your reply! I am using a MacBook Pro and the Mac OS is Big Sur 11.6.1.
I tried
sudo ln -s /usr/local/etc/odbcinst.ini /etc/odbcinst.ini sudo ln -s /usr/local/etc/odbc.ini /etc/odbc.ini and the output was
ln: /etc/odbcinst.ini: File exists ln: /etc/odbc.ini: File exists

I was able to install both msodbcsql17 and mssql-tools but I still got the error Error: nanodbc/nanodbc.cpp:1021: 00000: [unixODBC][Driver Manager]Can't open lib 'ODBC Driver 17 for SQL Server' : file not found. I tried to uninstall msodbcsql17 using brew uninstall --ignore-dependencies msodbcsql17.

Then I couldn't reinstall it because of outdated command line tool. I updated my macOS and tried to reinstall, but now I am getting the error in the subject line. I am not sure whether my force uninstall was causing any issue.

The output of ls /usr/local/Cellar/unixodbc/ is 2.3.9_1

The output of odbcinst -j is
unixODBC 2.3.9 DRIVERS............: /usr/local/etc/odbcinst.ini SYSTEM DATA SOURCES: /usr/local/etc/odbc.ini FILE DATA SOURCES..: /usr/local/etc/ODBCDataSources USER DATA SOURCES..: /Users/administrator/.odbc.ini SQLULEN Size.......: 8 SQLLEN Size........: 8 SQLSETPOSIROW Size.: 8

from homebrew-mssql-release.

Is it an ARM machine or not? The output you've posted suggests it's not, or you may be running under Rosetta2 emulation.

from homebrew-mssql-release.

I don't think it is an ARM machine. The processor is 2.8 GHz Quad-Core Intel Core i7. I am not running under Rosetta2 emulation. Apologies if I misunderstood your question.

from homebrew-mssql-release.

True, that is not ARM. Thus the paths are correct. Try to uninstall and reinstall from clean.
Note that due to #59 you may receive an OpenSSL error, in which case the workarounds suggested there should work.

from homebrew-mssql-release.

@v-chojas, I seem to be having the above problem with ARM (Apple M1 Max) Chip!

Installed ODBC using homebrew. This is the output of odbcinst -j:

unixODBC 2.3.9
DRIVERS............: /opt/homebrew/etc/odbcinst.ini
SYSTEM DATA SOURCES: /opt/homebrew/etc/odbc.ini
FILE DATA SOURCES..: /opt/homebrew/etc/ODBCDataSources
USER DATA SOURCES..: /Users/xxx/.odbc.ini
SQLULEN Size.......: 8
SQLLEN Size........: 8
SQLSETPOSIROW Size.: 8

I have also created symbolic links for /etc/odbcinst.ini and odbc.ini files.

But I'm getting error when trying to connect:
('01000', "[01000] [unixODBC][Driver Manager]Can't open lib '/opt/homebrew/lib/libmsodbcsql.17.dylib' : file not found (0) (SQLDriverConnect)")

Any idea?

from homebrew-mssql-release.

Does the file /opt/homebrew/lib/libmsodbcsql.17.dylib exist?

from homebrew-mssql-release.

I checked and it does exist. Would it possibly be permission issue?

from homebrew-mssql-release.

It should be readable and executable by all users, at least, so I don't think so. You can use the dtruss tool to see what files it is trying to access when you attempt to connect, and which one it doesn't find. Usually the "file not found' message indicates either the file, or one of its dependencies, is not found.

from homebrew-mssql-release.

Closing as inactive.

from homebrew-mssql-release.