title: Can't open lib 'ODBC Driver 13 for SQL Server'? Sym linking issue?
body: <p>When I try to connect to a sql server database with pyodbc (on mac):</p>
  
  <pre><code>import pyodbc
  
  server = '####'
  database = '####'
  username = '####@####'
  password = '#####'
  driver='{ODBC Driver 13 for SQL Server}'
  
  pyodbc.connect('DRIVER='+driver+';SERVER='+server+';PORT=1443;DATABASE='+database+';UID='+username+';PWD='+password)
  </code></pre>
  
  <p>I get the following error:</p>
  
  <blockquote>
    <p>Error: ('01000', "[01000] [unixODBC][Driver Manager]Can't open lib 'ODBC Driver 13 for SQL Server' : file not found (0) (SQLDriverConnect)")</p>
  </blockquote>
  
  <p>When I path in the actual driver location:</p>
  
  <pre><code>driver='/usr/local/lib/libmsodbcsql.13.dylib'
  </code></pre>
  
  <p>It starts working!</p>
  
  <p>My <code>odbcinst.ini</code> looks like this:</p>
  
  <pre><code>[ODBC Driver 13 for SQL Server]
  Description=Microsoft ODBC Driver 13 for SQL Server
  Driver=/usr/local/lib/libmsodbcsql.13.dylib
  UsageCount=1
  </code></pre>
  
  <p>How can I get my reference to <code>driver='{ODBC Driver 13 for SQL Server}'</code> to start working again?</p>
  
  <p>I initially used <a href="https://docs.microsoft.com/en-us/azure/sql-database/sql-database-connect-query-python" rel="noreferrer">this guide</a> to install the driver. And I'm using anaconda on Mac Sierra if that helps?</p>