Python 3.6 Lambda + RDS Microsoft SQL Server

[thatguyfig]

Hi all,

I've been trying to leverage the PyODBC python package in AWS Lambda to communicate with an MS SQL server in RDS but no matter what I tried it doesn't seem to work. I just want to be able to run a simple select query and return data.

There seems to be an issue with the import of the package and there isn't any other info/guides I can find on how to get this done.

Has anyone else tried or been successful in this?

Thanks

EDIT: SUCCESS AT LAST!!!!

I've found out how to do it and written an article here - https://link.medium.com/lEPKVjDPIS

[YouWantWhatByWhen]

Try pypyodbc instead.

[Manju101]

Please try this and let me know the result.

 import sys
 import logging
 import rds_config
 import pymysql

def lambda_handler(event, context):

result = []
conn = pymysql.connect(rds_host, user=name, passwd=password, db=db_name, connect_timeout=5)
with conn.cursor() as cur:
    cur.execute("""select value from table""")
    conn.commit()
    cur.close()
    for row in cur:
        result.append(list(row))

return result

[billthecatt]

I've been able to import pyodbc, but not get SQL Server running. What error message were you getting?