I’m trying to create an AWS Lambda Layer using Python 3.12 and pyodbc. I’ve seen a few different sites where they use an older version of Python and, when I try to translate to 3.12, it fails miserably.No matter how I build the zip file to upload, when I click the button to test my Lambda function, it tells me that pyodbc is not found.

In the end, my goal is to have a Lambda Layer using Python 3.12 that will allow me to communicate with an MS SQL Server database that is not an RDS.

Any help and insights would be greatly appreciated.

I have tried using docker but, once inside, the only download capability I seem to have is using dnf which doesn’t have libodbc.so.2. Docker is also missing key functionality like dpkg, yum, and/or apt-get. I’ve tried pulling down a few already-packaged version (mostly Python 3.8) but the files for msodbcsql and unixODBC don’t seem to match up. I have also tried building pymssql and that has fallen flat also.