How to set a DB connection timeout for a python/pyodbc/unixODBC/MS ODBC Driver 11 for SQL Server/Linux stack?
https://stackoverflow.com/a/12946908/1552953
This answer refers to being able to set a timeout on the connection:
Timeout
An optional integer query timeout, in seconds. Use zero, the default, to disable.
The timeout is applied to all cursors created by the connection, so it cannot be changed for a given connection.
If a query timeout occurs, the database should raise an OperationalError with SQLSTATE HYT00 or HYT01.
Note: This attribute only affects queries. To set the timeout for the actual connection process, use the timeout keyword of the pyodbc.connect function.
result = Nonewith pyodbc.connect('DRIVER={SQL Server};SERVER=mydb;DATABASE=solarwinds;Trusted_Connection=True', timeout=1) as cnxn: cursor = cnxn.cursor() result = cursor.execute(query).fetchall()So using the above code it didn't timeout within 1 second, or at least it didn't return a result within 1 second. But it did return a result much faster than without a timeout set.