title: ODBC Driver 17 for SQL Server on apple M1
body: <p>I am trying to get ODBC Driver 17 for SQL Server to work but somehow it doesn't on my brand new apple M1.
  Apparently I got unixodbc installed and also the driver, but starting them doesn't work. Looks like the odbc driver is not yet ready for the architecture (see below output). Doesn't even look like an issue with the microsoft driver, but the general lib from unixodbc - am I correct?</p>
  <p>Any ideas if it's possible to compile this on my own?</p>
  <pre><code>XXX@M1 ~ % 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
  XXX@M1 ~ % sqlcmd
  dyld: Library not loaded: /usr/local/lib/libodbc.2.dylib
    Referenced from: /opt/homebrew/bin/sqlcmd
    Reason: no suitable image found.  Did find:
      /usr/local/lib/libodbc.2.dylib: mach-o, but wrong architecture
      /usr/local/lib/libodbc.2.dylib: mach-o, but wrong architecture
      /opt/homebrew/Cellar/unixodbc/2.3.9/lib/libodbc.2.dylib: mach-o, but wrong architecture
      /opt/homebrew/Cellar/unixodbc/2.3.9/lib/libodbc.2.dylib: mach-o, but wrong architecture
  </code></pre>