title: ODBC Library Not Found error
body: <p>I've written a python script on my raspberry pi (OS: Raspbian) that I intend to use to populate a table in an MSSQL database, but I'm getting an error when trying to connect to it.  I'm using pypyodbc to achieve what I want.</p>
  
  <p>My connection string looks like this:-</p>
  
  <pre><code>connection = pypyodbc.connect('Driver={SQL Server};' 'Server=mssql2008.aspnethosting.co.uk, 14330;' 'Database=not_telling_you;' 'uid=not_telling_you; pwd=not_telling_you')
  </code></pre>
  
  <p>The error I'm getting is:-</p>
  
  <pre><code>Traceback (most recent call last):
    File "/home/pi/Documents/Python/Competitions.py", line 7, in &lt;module&gt;
      import pypyodbc
    File "/usr/local/lib/python2.7/dist-packages/pypyodbc.py", line 439, in &lt;module&gt;
      raise OdbcNoLibrary('ODBC Library is not found. Is LD_LIBRARY_PATH set?')
  OdbcNoLibrary: 'ODBC Library is not found. Is LD_LIBRARY_PATH set?'
  </code></pre>
  
  <p>I can't find anything online that tells me how to deal with this.  I've literally followed the instructions from <a href="https://blogs.msdn.microsoft.com/cdndevs/2015/03/11/python-and-data-sql-server-as-a-data-source-for-python-applications/" rel="nofollow noreferrer">https://blogs.msdn.microsoft.com/cdndevs/2015/03/11/python-and-data-sql-server-as-a-data-source-for-python-applications/</a> and I don't really know what to do to fix.  Hopefully you can help.</p>