title: Install ODBC Driver for Mac pyodbc
body: <p>Working with my Mac trying to connect to SQL Server database.  Following <a href="https://docs.microsoft.com/en-us/sql/connect/odbc/linux-mac/installing-the-microsoft-odbc-driver-for-sql-server?view=sql-server-2017" rel="nofollow noreferrer">Microsoft's instructions</a>.  However, when I enter:</p>
  
  <pre><code>brew install --no-sandbox msodbcsql@13.1.9.2 mssql-tools@14.0.6.0
  </code></pre>
  
  <p>I get the error:</p>
  
  <pre><code>odbcinst: SQLInstallDriverEx failed with Invalid install path.
  </code></pre>
  
  <p>If I install the ODBC driver (on top of Microsoft's instructions web page) and manually load into python script, is that possible?  Here is my python code:</p>
  
  <pre><code>import pyodbc
  import pandas as pd
  
  cnxn = pyodbc.connect("Driver={SQL Server Native Client 11.0};"
                         "Server=server_name;"
                         "Database=Sandbox;"
                         "uid=username;pwd=password")
  df = pd.read_sql_query('select * from table', cnxn)
  </code></pre>
  
  <p>In this code, how would I replace the zipped downloaded driver to the connect statement, thus bypassing brew?</p>