28,658 questions
Have you installed the driver?
Data source name not found and no default driver specified
![](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)
TheExecutable
15
Reputation points
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.
Windows for business | Windows Client for IT Pros | User experience | Other
SQL Server | Other
14,500 questions
{count} votes
-
![](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)
Seeya Xi-MSFT 16,586 Reputation points2023-04-03T07:51:10.95+00:00 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
-
Seeya Xi-MSFT 16,586 Reputation points
2023-04-04T08:27:13.43+00:00 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
Sign in to comment
2 answers
Sort by: Most helpful
-
![](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)
Bruce (SqlWork.com) 78,006 Reputation points Volunteer Moderator2023-03-30T15:24:35.83+00:00 -
Seeya Xi-MSFT 16,586 Reputation points
2023-03-31T06:22:41.18+00:00 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".