Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
I'm trying to connect a Fabric notebook (PySpark) to Azure SQL server using pyodbc but keep receiving the following error when using ODBC Driver 18 for SQL server:
OperationalError: ('HYT00', '[HYT00] [Microsoft][ODBC Driver 18 for SQL Server]Login timeout expired (0) (SQLDriverConnect)')
Can anyone help? I don't want to input my password into the notebook.
Solved! Go to Solution.
Notebooks don't support this kind of connectivity.
Notebooks don't support this kind of connectivity.
Hi @awbanksh ,
Glad you have got a resolution for the error. Please continue using Fabric Community for help regarding your queries.
Hi,
Are you sure a notebook supports interactive authentication? This would be new for me. Try using user and password and don't forget to handle the azure sql firewal
Kind Regards,
Dennes
Hi @awbanksh ,
We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet. Please let us know if you have any further queries.
Ask questions in Data Engineering, Data Science, Data Warehouse and General Discussion.
Check out the April 2024 Fabric update to learn about new features.