Getting pyodbc to connect in AWS Lambda Layer

Question

I have built deployment package to connect to a AWS RDS instance via pyodbc, after zipping up and uploading to AWS lambda this connection works.

When trying to connect via an AWS layer, following error is displayed.

"errorMessage": "('01000', \"[01000] [unixODBC][Driver Manager]Can't open lib 'ODBC Driver 13 for SQL Server' : file not found (0) (SQLDriverConnect)\")",
  "errorType": "Error",

Tried to change the path for the driver in the odbcinst.ini file, but with no luck

Example of text in odbcinst.ini file

[ODBC Driver 13 for SQL Server]
Description=Microsoft ODBC Driver 13 for SQL Server
Driver=/var/task/msodbcsql/lib64/libmsodbcsql-13.1.so.9.2
UsageCount=1

medium.com/@narayan.anurag/… might be of interest.

narayan
– narayan

2020-10-13 02:27:27 +00:00
Commented Oct 13, 2020 at 2:27 — narayan
– narayan, Commented Oct 13, 2020 at 2:27

Neil C. Obremski · Accepted Answer · 2020-02-15 16:01:21Z

3

If you're willing to use ODBC Driver 17 then I recommend Alexander's pyodbc layer which you can find on GitHub: https://github.com/alexanderluiscampino/lambda-layers

There's also a discussion of it when it was first being constructed that can be helpful for context: https://gist.github.com/diriver63/b72a954fa0da4851d89e5086aa13c6e8

I've used this myself and had good luck with it. I originally found it after finding that pyodbc has no binary wheels and so AWS SAM can't simply install it: https://github.com/awslabs/aws-sam-cli/issues/1577

answered Feb 15, 2020 at 16:01

Neil C. Obremski

20.6k26 gold badges102 silver badges136 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Getting pyodbc to connect in AWS Lambda Layer

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related