search

microsoft / homebrew-mssql-release

Other
92 stars 31 forks source link

Problems installing msodbcsql17 and mssql-tools #66

Closed rahulsarabu closed 2 years ago

rahulsarabu commented 2 years ago

Im using Spyder (Ananconda) to connect to MS sql server using pyodbc. Im working on Apple M1 chip, 2021 make. Python didnt recognize the unixodbc driver initially and sent an error to install x86-64 version instead of arm64. i then uninstalled brew completely and installed x86-64 with rosetta. Python now recognizes the unixodbc driver and able to import pyodbc package. To connect to mssql server, i need to install mssql-tools and msodbcsql17, it doesnt throw any error while installing the ms drivers, installation just skips. attaching some needful information below.

msodbcsql17 and mssql-tools installation: bash-3.2$ brew install mssql-tools msodbcsql17 ==> Downloading https://download.microsoft.com/download/1/9/A/19AF548A-6DD3-4B48-88DC-724E9ABCEB9A/msodbcsql17-17.8.1.1-amd64.tar.gz Already downloaded: /Users/v0s03aa/Library/Caches/Homebrew/downloads/4e244e94bb2cf243bfb6a52aa7e894e6302f742b4a39a46aeab827c75e3661ca--msodbcsql17-17.8.1.1-amd64.tar.gz ==> Downloading https://download.microsoft.com/download/F/D/1/FD16AA69-F27D-440E-A15A-6C521A1972E6/mssql-tools-17.8.1.1-amd64.tar.gz Already downloaded: /Users/v0s03aa/Library/Caches/Homebrew/downloads/647f6e1067f9bae2f6d5568ce5d08630eea5d36135c117922d8a857fc852a623--mssql-tools-17.8.1.1-amd64.tar.gz ==> Installing mssql-tools from microsoft/mssql-release ==> Installing dependencies for microsoft/mssql-release/mssql-tools: msodbcsql17 ==> Installing microsoft/mssql-release/mssql-tools dependency: msodbcsql17 The license terms for this product can be downloaded from https://aka.ms/odbc17eula and found in /usr/local/share/doc/msodbcsql17/LICENSE.txt . By entering 'YES', you indicate that you accept the license terms.

Do you accept the license terms? (Enter YES or NO) YES ==> odbcinst -u -d -n "ODBC Driver 17 for SQL Server" Last 15 lines from /Users/v0s03aa/Library/Logs/Homebrew/msodbcsql17/01.odbcinst: 2021-12-28 16:54:05 +0000

odbcinst -u -d -n "ODBC Driver 17 for SQL Server"

If reporting this issue please do so at (not Homebrew/brew or Homebrew/core): https://github.com/microsoft/homebrew-mssql-release/issues

Python version bash-3.2$ python --version Python 3.9.7

odbc version bash-3.2$ odbcinst -j unixODBC 2.3.9 DRIVERS............: /etc/odbcinst.ini SYSTEM DATA SOURCES: /etc/odbc.ini FILE DATA SOURCES..: /etc/ODBCDataSources USER DATA SOURCES..: /Users/v0s03aa/.odbc.ini SQLULEN Size.......: 8 SQLLEN Size........: 8 SQLSETPOSIROW Size.: 8

Any help on this is highly appreciated.

vwarchu commented 2 years ago

Thanks for the report - we'll look into this

v-chojas commented 2 years ago

I do not see any errors in your description - what, if any, errors are you seeing?

v-chojas commented 2 years ago

Closing due to inactivity. Reopen and post any errors if you do manage to find them.