timeout parameter on connection object

[rkudulis]

Is there any way to set a timeout parameter for connection object like pyodbc has.

cnxn = pyodbc.connect(connString)  
cnxn.timeout = 3

OR

cnxn = pyodbc.connect(connString, timeout = 3)

[pacman82]

AFAIK turbodbc does not allow to set a connection timeout.

In case someone wants to implement it though:

You can set SQL_ATTR_CONNECTION_TIMEOUT using SQLSetConnectionAttr.

An SQLUINTEGER value corresponding to the number of seconds to wait for any request on the connection to complete before returning to the application. The driver should return SQLSTATE HYT00 (Timeout expired) anytime that it is possible to time out in a situation not associated with query execution or login.

If ValuePtr is equal to 0 (the default), there is no timeout.

See: https://docs.microsoft.com/en-us/sql/odbc/reference/syntax/sqlsetconnectattr-function?redirectedfrom=MSDN&view=sql-server-ver15

Edit: Other timeouts (just realized I do not know which timeout the pyodbc timeout refers, too):

SQL_ATTR_LOGIN_TIMEOUT