Login time out error for pyodbc connection string in kedro
I'm trying to build up connection string in kedro for SQLQueryDataset to set the connection with MSSQL and Pyodbc in Azure Databricks but encountered with an error:
(pyodbc.OperationalError) ('HYT00', '[HYT00] [Microsoft][ODBC Driver 17 for SQL Server]Login timeout expired (0) (SQLDriverConnect)')
Setting up connection string in credentials.yml file as
con:
mssql+pyodbc://${sql_username}:${sql_password}@{sql_server_name}/{database_name}?...