How to fix delayed TDS version error with pymssql when running backend app service

Question

I have an issue when deploying my python flask application, it connects to an azure db using pymssql. For about an hour after deployment, there are no issues and the flask server works as intended. However, after a bit this error starts to show up and any calls out to the db result in this error in the app logs. Not sure whats going on, in my code I am :

self.conn = pymssql.connect(
            server='*',
            user='*',
            password='*',
            database='*',
            as_dict=True,
            tds_version='7.3'
        )

to try and set the tds_version, but with or without setting this in the connect the error shows up after some amount of time.

Answer 1

Hi Jakob B,

Welcome to Microsoft Q&A forum.

As I understand, you want to know How to fix delayed TDS version error with pymssql when running backend app service.

As per the screenshot and the error, it states that "stored procedures are not supported with a tds version less than 7".

Try updating client library used for connection to SQL Server.

Let us know if this helps.

Thanks