Connect Sql Server 2014 to Django 2.2

Question

I am trying to connect the Sql Server database to Django but am getting the following error(The connector I am using is Django-pyodbc-Azure):

Django.db.utils.Interfaceerror: ('IM002', '[IM002] [Microsoft][ODBC Driver Manager] Name of data source not found and no default driver specified (0) (Sqldriverconnect)')

The setings.py configuration:

DATABASES = {
'default': {
    'ENGINE': 'sql_server.pyodbc',
    'NAME': 'name',
    'USER': 'user',
    'PASSWORD': '1234',
    'HOST': '127.0.0.1\test',
    'PORT': '1433',
},}

Dependencies:

Django==2.2.4
django-pyodbc-azure==2.1.0.0

Someone could help with that?

Answer 1

The problem is the compatibility between Django and python, when I used pyodbc with Python 3.4.4 and Django == 2.2.4 worked, and that’s what I did:

-install Python 3.4.4 CMD Pip install virtualenv test

virtual test

. \ Scripts enable

Pip install Django == 2.2.4 Pip install Django-mssql

Pip install https://www.lfd.uci.edu/~gohlke/pythonlibs/#pywin32

Django-admin startproject meuprojeto.

Modify settings database

 DATABASES = {    'default': {
>        'ENGINE': 'sqlserver_ado',
>        'HOST': 'USER-PC\SQL2019',  # Substitua pelo nome do host em que o servidor MSSQL está sendo executado
>        'NAME': 'test',  # Substitua pelo nome do banco de dados no servidor MSSQL
>        'USER': 'USER',  # Substitua pelo nome de usuário
>        'PASSWORD': '1234',  # Substitua pela senha    }, }