Issue installing on MacOS
nbrow opened this issue · 8 comments
Tried to install in the Terminal but Home Brew doesn't seem to have a msodbcsql17 formulae to install. I received this message:
(base) Nicholass-MacBook-Pro:~ Nick$ Error: No available formula with the name "msodbcsql17"
==> Searching for a previously deleted formula (in the last month)...
Error: No previously deleted formula found.
==> Searching for similarly named formulae...
Error: No similarly named formulae found.
==> Searching taps...
==> Searching taps on GitHub...
Error: No formulae found in taps.
Did you run these commands first?
brew tap microsoft/mssql-release https://github.com/Microsoft/homebrew-mssql-release
brew update
...then try to install msodbcsql17, if you are still seeing errors then please post transcript of entire terminal session for further assistance.
I was able to install but my system does not find the OBDC when I try to open. Is there a configuration or setup necessary after installing?
I am not sure what you mean by "does not find the OBDC when I try to open". Could you explain more about what you are trying to do?
Sure, I'm looking to get access to a MS Database in Open Office. When I go to select an ODBC, nothing is available.
You need to create a DSN first. Run odbcinst -j to find the location of the odbc.ini file, then add a DSN entry to it.
See http://www.unixodbc.org/odbcinst.html for more information.
Here was the output:
(base) Nicholass-MacBook-Pro:~ Nick$ odbcinst -j
unixODBC 2.3.7
DRIVERS............: /etc/odbcinst.ini
SYSTEM DATA SOURCES: /etc/odbc.ini
FILE DATA SOURCES..: /etc/ODBCDataSources
USER DATA SOURCES..: /Users/Nick/.odbc.ini
SQLULEN Size.......: 8
SQLLEN Size........: 8
SQLSETPOSIROW Size.: 8
I'm not sure how to add a DSN entry.