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)')

claudio cardenas diaz 1 Reputation point
2021-11-19T17:53:23.703+00:00

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)')

151035-image.png

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,323 questions
{count} votes

1 answer

Sort by: Most helpful
  1. Seeya Xi-MSFT 16,416 Reputation points
    2021-11-22T06:08:35.59+00:00

    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.

    0 comments No comments