title: Problem with connecting to MS SQL Server with Python AWS Lambda Layer - ODBC Driver 13 for SQL Server
body: <p>I am in the process of setting up an AWS lambda function to connect to a MS SQL Server database using pyodbc to extract records from a table.</p>
  
  <p>I am receiving an error message </p>
  
  <pre><code>('01000', "[01000] [unixODBC][Driver Manager]Can't open lib 'ODBC Driver 13 for SQL Server' : file not found (0) (SQLDriverConnect))
  </code></pre>
  
  <p>I have built a deployment package on a linux EC2 instance) using the process detailing in the following post:
  <a href="https://gist.github.com/carlochess/658a98589709f46dbb3d20502e48556b" rel="nofollow noreferrer">https://gist.github.com/carlochess/658a98589709f46dbb3d20502e48556b</a></p>
  
  <p>I have read extensively on this and have changed the path in the odbcinst.ini file to match the directory structure of the lambda layer, but with no luck.</p>
  
  <p>I have also  directory referenced the location of the driver file (libmsodbcsql-13.1.so.9.2).</p>
  
  <p>The error message changes slightly to state that it cannot find the driver efile at the certain location(even though the file does exist)</p>