title: Can't open lib 'FreeTDS' : file not found (0) (SQLDriverConnect) Unable to connect MSSQL using PyODBC
body: <p>I'm trying to connect to a SQL Server using Pypyodbc on Mac and I'm getting the following error:</p>
  
  <pre><code>Driver Manager]Can't open lib 'FreeTDS' : file not found (0) (SQLDriverConnect)
  </code></pre>
  
  <p>Below is my code:</p>
  
  <pre><code>import pyodbc
  conn = pyodbc.connect('DRIVER={FreeTDS};DSN=MYMSSQL;UID=&lt;&gt;;PWD=&lt;&gt;')
  crsr = conn.cursor()
  rows = crsr.execute("SELECT * FROM transaction_detail_check").fetchall()
  print(rows)
  crsr.close()
  conn.close()
  </code></pre>
  
  <p>odbcinst.ini
  <a href="https://i.stack.imgur.com/B3dU0.jpg" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/B3dU0.jpg" alt="enter image description here"></a></p>
  
  <p>odbc.ini</p>
  
  <p><a href="https://i.stack.imgur.com/1edKb.jpg" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/1edKb.jpg" alt="enter image description here"></a></p>
  
  <p>freetds.conf</p>
  
  <p><a href="https://i.stack.imgur.com/fsrOp.jpg" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/fsrOp.jpg" alt="enter image description here"></a></p>
  
  <p>Can someone please help ?  Thanks</p>