Django - DATABASES configuration

Question

DATABASES = { 'default': { 'ENGINE': 'sql_server.pyodbc', 'NAME': 'name',

The string of ODBC only use the attribute DATABASE, but Django only executes with the attribute NAME. How can I resolve this conflict? Grateful!

Answer 1

Adriano, when you are setting up in Settings the database as illustrated by vc in the question, you are creating a dictionary that will represent key and value. If the DATABASE attribute is required you can put it as:

DATABASES = {
    'default': {
        'DATABASE_ENGINE': 'sql_server.pyobdc',
        'DATABASE_NAME': 'name',
        ...
    }
}

don’t forget to do pyobdc installation by not being native to Django

pip install sql_server.pyodbc

Answer 2

Standard Django: DATABASES = { 'default': { 'ENGINE': 'sql_server.pyodbc', 'HOST': 'xxx', 'NAME': 'xxx', 'USER': 'xxx', 'PASSWORD': 'xxx', 'PORT': 'xxx', 'OPTIONS': { 'driver': 'ODBC Driver 17 for SQL Server', }, }, }

As ODBC did not recognize the NAME key and Django DATABASE. I added extra_params using the DATABASE key DATABASES = { 'default': { 'ENGINE': 'sql_server.pyodbc', 'HOST': 'xxx', 'NAME': 'xxx', 'USER': 'xxx', 'PASSWORD': 'xxx', 'PORT': 'xxx', 'OPTIONS': { 'driver': 'ODBC Driver 17 for SQL Server', 'extra_params': 'DRIVER={ODBC Driver 17 for SQL Server};SERVER=xxx;DATABASE=xxx;USER=xxx;PASSWORD=xxx;Trusted_connection=Yes', }, }, }