#Microstrategy desktop odbc driver for sql server driver#
In Python, there are 2 main ways for connecting to SQL Server, using the pyodbc module and Microsoft ODBC Driver 17 for SQL Server.
![microstrategy desktop odbc driver for sql server microstrategy desktop odbc driver for sql server](https://www.cdata.com/kb/articles/odbc-microstrategy-9.png)
Ways of Connecting to SQL Server from Python
![microstrategy desktop odbc driver for sql server microstrategy desktop odbc driver for sql server](https://i.stack.imgur.com/n860Z.png)
Prior to sharing our tips for troubleshooting the issue, let’s discuss about the two main ways of connecting to SQL Server from Python. This article, provides useful troubleshooting tips, for the following error which you might get, under certain circumstances, when trying to connect to SQL Server from Python, using pyodbc: Data source name not found and no default driver specified (0) (SQLDriverConnect).