title: How to install pymssql on MacOS Sierra
body: <pre><code>Command "/usr/bin/python -u -c "import setuptools, tokenize;__file__='/private/tmp/pip-build-J1I0ox/pymssql/setup.py';f=getattr(tokenize, 'open', open)(__file__);code=f.read().replace('\r\n', '\n');f.close();exec(compile(code, __file__, 'exec'))" install --record /tmp/pip-qmtdBW-record/install-record.txt --single-version-externally-managed --compile" failed with error code 1 in /private/tmp/pip-build-J1I0ox/pymssql/
  </code></pre>
  
  <p>I am having the same error as displayed <a href="https://stackoverflow.com/questions/30646171/error-installing-pymssql-on-mac-os-x-yosemite">here</a> . I followed the instructions on that page by trying <code>brew install freetds</code> followed by <code>sudo -H pip install pymssql</code>.</p>
  
  <p>That generates this error code:</p>
  
  <pre><code>    _mssql.c:18814:15: error: use of undeclared identifier 'DBVERSION_80'
      __pyx_r = DBVERSION_80;
                ^
  4 warnings and 1 error generated.
  error: command 'cc' failed with exit status 1
  
  ----------------------------------------
  Command "/usr/bin/python -u -c "import setuptools, tokenize;__file__='/private/tmp/pip-build-J1I0ox/pymssql/setup.py';f=getattr(tokenize, 'open', open)(__file__);code=f.read().replace('\r\n', '\n');f.close();exec(compile(code, __file__, 'exec'))" install --record /tmp/pip-qmtdBW-record/install-record.txt --single-version-externally-managed --compile" failed with error code 1 in /private/tmp/pip-build-J1I0ox/pymssql/
  </code></pre>
  
  <p>Searching this error brought me to <a href="https://stackoverflow.com/questions/37771434/mac-pip-install-pymssql-error"> this page</a>. I followed the solution posted there by trying both <code> brew unlink freetds; brew install homebrew/versions/freetds091</code> and <code> brew uninstall freetds; brew install homebrew/versions/freetds091</code> which generates a different error when trying <code> sudo -H pip install pymssql</code>:</p>
  
  <pre><code>_mssql.c:266:10: fatal error: 'sqlfront.h' file not found
  #include "sqlfront.h"
           ^
  1 error generated.
  error: command 'cc' failed with exit status 1
  
  ----------------------------------------
  Command "/usr/bin/python -u -c "import setuptools, tokenize;__file__='/private/var/folders/_s/27xppw4j3yl78c9l4v1w3n9m0000gn/T/pip-build-97A9sQ/pymssql/setup.py';f=getattr(tokenize, 'open', open)(__file__);code=f.read().replace('\r\n', '\n');f.close();exec(compile(code, __file__, 'exec'))" install --record /var/folders/_s/27xppw4j3yl78c9l4v1w3n9m0000gn/T/pip-0nUZo4-record/install-record.txt --single-version-externally-managed --compile" failed with error code 1 in /private/var/folders/_s/27xppw4j3yl78c9l4v1w3n9m0000gn/T/pip-build-97A9sQ/pymssql/
  </code></pre>
  
  <p>So then I gave up and tried to install pyodbc, but I still get similar errors: <code> src/pyodbc.h:56:10: fatal error: 'sql.h' file not found
      #include sql.h </code></p>
  
  <p>Any help with this would be great.</p>