This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(265.6, 38%, 35%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ET%3C/text%3E%3C/svg%3E)
Dear everyone
I am trying to connect to an mssql server via Python using the pyodbc package. I have the following code
1. import pyodbc
2.
3. cnxn_str = ("Driver={SQL Server Native Client 11.0};"
4. "Server=MyServer;"
5. "Database=Test;"
6. "Trusted_Connection=yes;")
7.
8. cnxn = pyodbc.connect(cnxn_str)
I keep getting the error message "Data source name not found and no default driver specified" from line 8. I have tried using "SQL Server Native Client 11.0" as well as "odbc driver 18 for sql server" as a Driver if someone is curious.
The full Traceback is:
Traceback (most recent call last):
File "d:\Database\test.py", line 8, in <module>
cnxn = pyodbc.connect(cnxn_str)
pyodbc.InterfaceError: ('IM002', '[IM002] [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified (0) (SQLDriverConnect)')
PS D:\Database>
Can anyone guide me through how to connect succesfully and execute queries on a MSSQL with Python using the pyodbc package? I have read the documentation and can't really seem to see why I keep getting the above error. Do I need to download something external or configure my MSSQL in a different way? Thanks in advance.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(28.799999999999997, 2%, 12%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESX%3C/text%3E%3C/svg%3E)
Hi @TheExecutable ,
We have not received a response from you. Did the reply could help you? If the response helped, do "Accept Answer". If it doesn't work, please let us know the progress. By doing so, it will benefit all community members who are having this similar issue. Your contribution is highly appreciated.
Best regards,
Seeya
Hi @TheExecutable , In order to benefit all community members who are having this similar issue, please choose an answer to accept or vote for the answer you think is useful to you. Your contribution is highly appreciated. Best regards, Seeya
Hi @TheExecutable ,
Please refer to this similar thread:
You can check the DSN 64-bit with ODBC Data Source Administrator if you are using a 64-bit version of Windows( If you are on 32-bit Windows, select 32-bit).
Best regards,
Seeya
If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(211.20000000000002, 61%, 30%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EBS%3C/text%3E%3C/svg%3E)
Have you installed the driver?
