[Python] Is there a way I could connect SQL server to Python(pandas) using Windows...

I tried connecting it with pyodbc library but I'm having a driver error that says:

[08001] [Microsoft] [ODBC SQL server Driver] [DBNETLIB]SQL SERVER does not exist or access denied
​

I just wanted to confirm if it was because my SQL server was kept in Windows authentication mode when logging into the server that doesn't require password or using password and sa(system authentication)?

I tried checking if Python detects the driver which came out True then I used the code:

Conn =pyodbc.connect('Driver = ODBC Driver 17 for SQL server'; 'Server =DESKTOP-20DARUKL/SQLEXPRESS'; 'database = Master'; 'Trusted_connection = True'


After importing pyodbc. I was expecting it to connect but I had an error. I was expecting Python to connect to my SQL server database

Continue reading...