How to fix timeout error in connection using pyodbc in airflow

Xavier Langa 0

Hi,

I am running an airflow DAG in docker, where I connect to sql server 2019 using a pyodbc connection function.

My connection function is as:

def get_db_connection():
    return pyodbc.connect(
        'DRIVER={ODBC Driver 17 for SQL Server};'
        'SERVER=xxx.xxx.x.xx\\XXX2024;'
        'DATABASE=somedatabase;'
        'UID=username;'
        'PWD=password;'
    )

When the connection exceeds 15 seconds, I get this error:

return pyodbc.connect( pyodbc.OperationalError: ('HYT00', '[HYT00] [Microsoft][ODBC Driver 17 for SQL Server]Login timeout expired (0) (SQLDriverConnect)')

even when setting:

connection.timeout = 30

Can someone help me?

Erland Sommarskog 112.8K Reputation points MVP

2024-11-23T10:48:40.4233333+00:00

"When the connection exceeds?" That kind of suggests that sometimes it does not and connection succeeds? Or does it always fail?

I don't have too much of an idea, but I played a little, and it seems that it the server and/or instance name is wrong, you get a different error message. I also did a silly test where I added a logon trigger with a WAITFOR. In this case, I got this error message:

pyodbc.OperationalError: ('08001', '[08001] [Microsoft][ODBC Driver 17 for SQL Server]Shared Memory Provider: Timeout error [258]. (258) (SQLDriverConnect); [08001] [Microsoft][ODBC Driver 17 for SQL Server]Login timeout expired (0); [08001] [Microsoft][ODBC Driver 17 for SQL Server]Unable to complete login process due to delay in login response (258)')

You did not get the second part, but possibly this is because you get stuck earlier.

Share via

How to fix timeout error in connection using pyodbc in airflow

Your answer