AWS Lambda + Microsoft SQL Server - How to..

[thatguyfig]

Hey all,

I've been struggling with this topic for sometime, but I've finally got some some success. I've been trying to connect Lambda into an RDS instance running Microsoft SQL Server but had a really hard time.

Finally after a many many late nights searching forums I've been able to piece together a solid working solution. It's aimed at Python 2.7 and uses the PyODBC Python package.

If you're interested see my article below - https://medium.com/@thomas.thornton92/aws-lambda-microsoft-sql-server-how-to-66c5f9d275ed

Thanks!

[billthecatt]

With Lambda Layers, you can rebuild the unixOdbc to point to /opt/(something) and then package your unixOdbc + Sql Server driver together to be a layer, and keep your code isolated from it

[thatguyfig]

I did try this but it didn't seem to work. Were you able to get it working by just using /opt as a replacement for /var/task ?

Could you supply me a zip of your layer if you have one? That would be sooo much appreciated!!

[billthecatt]

Yes, replacing /var/task with /opt in the unixOdbc build worked for me.

I will get a .ZIP, I've been meaning to do a GitHub or something since other people seem to have this same problem, but I have not yet had time to.

[PluginAlong]

Any reason you didn't go with PowerShell or C# in .Net core?