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

[Franky1]

Just some ideas:

• try without the cache decorators
• use IP address of the database server

Here are some threads with similar issues:

pyodbc.OperationalError: This app has encountered an error

I googled the error message and found plenty of StackOverflow threads: python - pyodbc.OperationalError: ('HYT00', u'[HYT00] [unixODBC][Microsoft][ODBC Driver 13 for SQL Server]Login timeout expired (0) (SQLDriverConnect)') - Stack Overflow sql server - "Login timeout expired" error when accessing MS SQL db via sqlalchemy and pyodbc - Stack Overflow sql server - Pyodbc: Login Timeout Error - Stack Overflow "Login timeout expired" on Centos 7 · Issue #412 · mkleehammer/pyodbc · GitHub pyodbc.Op…

pyodbc.OperationalError - Issue connect Microsoft SQL Server

hi - I followed the instructions from this page [Connect Streamlit to Microsoft SQL Server] from streamlit documentation to get my remote Microsoft SQL Server connected, however I am stuck at this error: pyodbc.OperationalError: ('HYT00', '[HYT00] [Microsoft][ODBC Driver 17 for SQL Server]Login timeout expired (0) (SQLDriverConnect) The error is from this line of code: conn = init_connection() Thanks.