django pyodbc Data Source Name not found

Question

When Attempting to connect to my database server and database in Django, I am getting the error (django.db.utils.InterfaceError: ('IM002', '[IM002] [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified (0) (SQLDriverConnect)'), and I am not sure why

settings.py
DATABASES = {
    'default': {
        'ENGINE': 'sql_server.pyodbc',
        'NAME': 'MY_DATABASE_NAME',
        'HOST': '13.0.4001.0',
        'USER': 'MY_USERNAME',
        'PASSWORD': 'MY_PASSWORD',
        'CONN_MAX_AGE': 1000,
        'PORT': '8000',
        'OPTIONS': {
            'driver': 'ODBC Driver 13 for SQL Server',
        }
    },
}

How would I fix this error, and start getting/editing data from my database

Gustavo dos S. Morato · Accepted Answer · 2020-08-28 11:43:30Z

1

hi check the version of your SQL server and try download of drive connector , I was the same problem then i install the driver ODBC 17 and the problem was solved.

Drive SQL

answered Aug 28, 2020 at 11:43

Gustavo dos S. Morato

261 bronze badge

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

django pyodbc Data Source Name not found

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related