ERROR InterfaceError: ('IM002', '[IM002] [Microsoft][Administrador de controladores ODBC] No se encuentra el nombre del origen de datos y no se especificó ningún controlador predeterminado (0) (SQLDriverConnect)')

Question

Hi there, I try to connect to SQL Server with python in jupyter notebook
I was installed pyodbc then run my code.
and I have this problem

InterfaceError: ('IM002', '[IM002] [Microsoft][Administrador de controladores ODBC] No se encuentra el nombre del origen de datos y no se especificó ningún controlador predeterminado (0) (SQLDriverConnect)')

Answer 1

Hi @claudio cardenas diaz ,

Welcome to Microsoft Q&A!
You can use this script to check the driver.

import pyodbc  
print(pyodbc.drivers())  

If you do not find ODBC Driver 17 for SQL Server, then you need to install it first.
Download from here: https://www.microsoft.com/en-us/download/details.aspx?id=56567

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".
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.