![Using ODBC to connect any database directly to Jupyter notebook. | by Gaurav Chauhan | Towards Data Science Using ODBC to connect any database directly to Jupyter notebook. | by Gaurav Chauhan | Towards Data Science](https://miro.medium.com/v2/resize:fit:2000/1*kKCOUdwgut5ipYdH23u91A.jpeg)
Using ODBC to connect any database directly to Jupyter notebook. | by Gaurav Chauhan | Towards Data Science
![python - Remote connection to MS SQL - Error using pyodbc vs success using SQL Server Management Studio - Stack Overflow python - Remote connection to MS SQL - Error using pyodbc vs success using SQL Server Management Studio - Stack Overflow](https://i.stack.imgur.com/BLFIV.png)
python - Remote connection to MS SQL - Error using pyodbc vs success using SQL Server Management Studio - Stack Overflow
![pyodbc.Error: ('01000', "[01000] [unixODBC][Driver Manager]Can't open lib 'ODBC Driver for 17 SQL Server' : file not found (0) (SQLDriverConnect)") · Issue #878 · mkleehammer/pyodbc · GitHub pyodbc.Error: ('01000', "[01000] [unixODBC][Driver Manager]Can't open lib 'ODBC Driver for 17 SQL Server' : file not found (0) (SQLDriverConnect)") · Issue #878 · mkleehammer/pyodbc · GitHub](https://user-images.githubusercontent.com/2372774/109891250-ba538700-7c56-11eb-922e-19727295efc2.png)
pyodbc.Error: ('01000', "[01000] [unixODBC][Driver Manager]Can't open lib 'ODBC Driver for 17 SQL Server' : file not found (0) (SQLDriverConnect)") · Issue #878 · mkleehammer/pyodbc · GitHub
![pyodbc.ProgrammingError) ('42000', "[42000] [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Cannot find data type 'TEXT'. - Microsoft Q&A pyodbc.ProgrammingError) ('42000', "[42000] [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Cannot find data type 'TEXT'. - Microsoft Q&A](https://learn-attachment.microsoft.com/api/attachments/142349-a941b9a3-742d-45ae-8e1b-ef239f3c768f.png?platform=QnA)
pyodbc.ProgrammingError) ('42000', "[42000] [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Cannot find data type 'TEXT'. - Microsoft Q&A
![python - Django:[ODBC Driver 17 for SQL Server][SQL Server]Login failed for user 'test'. (18456) - Stack Overflow python - Django:[ODBC Driver 17 for SQL Server][SQL Server]Login failed for user 'test'. (18456) - Stack Overflow](https://i.stack.imgur.com/GC8pJ.png)
python - Django:[ODBC Driver 17 for SQL Server][SQL Server]Login failed for user 'test'. (18456) - Stack Overflow
![python - Django:[ODBC Driver 17 for SQL Server][SQL Server]Login failed for user 'test'. (18456) - Stack Overflow python - Django:[ODBC Driver 17 for SQL Server][SQL Server]Login failed for user 'test'. (18456) - Stack Overflow](https://i.stack.imgur.com/fwt9C.png)
python - Django:[ODBC Driver 17 for SQL Server][SQL Server]Login failed for user 'test'. (18456) - Stack Overflow
![ERROR]pyodbc.ProgrammingError: ('42000', '[42000] [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]SQL Server 阻止了对组件“xp_cmdshell”的过程“sys.xp_cmdshell”的访问- LeoShi2020 - 博客园 ERROR]pyodbc.ProgrammingError: ('42000', '[42000] [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]SQL Server 阻止了对组件“xp_cmdshell”的过程“sys.xp_cmdshell”的访问- LeoShi2020 - 博客园](https://img2018.cnblogs.com/i-beta/1940615/202002/1940615-20200212200835702-1256696323.png)
ERROR]pyodbc.ProgrammingError: ('42000', '[42000] [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]SQL Server 阻止了对组件“xp_cmdshell”的过程“sys.xp_cmdshell”的访问- LeoShi2020 - 博客园
![01000', "[01000] [unixODBC][Driver Manager]Can't open lib 'ODBC Driver 17 for SQL Server' : file not found (0) (SQLDriverConnect)") · Issue #717 · mkleehammer/pyodbc · GitHub 01000', "[01000] [unixODBC][Driver Manager]Can't open lib 'ODBC Driver 17 for SQL Server' : file not found (0) (SQLDriverConnect)") · Issue #717 · mkleehammer/pyodbc · GitHub](https://user-images.githubusercontent.com/25211973/128778163-8ed820d2-e750-4614-ae80-820ef41429ba.png)
01000', "[01000] [unixODBC][Driver Manager]Can't open lib 'ODBC Driver 17 for SQL Server' : file not found (0) (SQLDriverConnect)") · Issue #717 · mkleehammer/pyodbc · GitHub
![Microsoft][ODBC Driver 17 for SQL Server]Client unable to establish connection (0) (SQLDriverConnect)' · Issue #994 · mkleehammer/pyodbc · GitHub Microsoft][ODBC Driver 17 for SQL Server]Client unable to establish connection (0) (SQLDriverConnect)' · Issue #994 · mkleehammer/pyodbc · GitHub](https://user-images.githubusercontent.com/94332384/150817985-24abedff-9e6f-4d98-99d3-0c6067aa1cdf.png)
Microsoft][ODBC Driver 17 for SQL Server]Client unable to establish connection (0) (SQLDriverConnect)' · Issue #994 · mkleehammer/pyodbc · GitHub
Microsoft][ODBC Driver 17 for SQL Server]Client unable to establish connection (0) (SQLDriverConnect)' · Issue #994 · mkleehammer/pyodbc · GitHub
![Error [HYT00] [Microsoft][ODBC Driver 17 for SQL Server]Login timeout expired · Issue #110 · ESSolutions/django-mssql-backend · GitHub Error [HYT00] [Microsoft][ODBC Driver 17 for SQL Server]Login timeout expired · Issue #110 · ESSolutions/django-mssql-backend · GitHub](https://user-images.githubusercontent.com/40257388/110893303-773b8880-82d4-11eb-95a1-47b9922aa118.png)