[Python] Connecting Django with MSSQL server

Discussão em 'Python' iniciado por Stack, Abril 11, 2025.

  1. Stack

    Stack Membro Participativo

    I'm trying to connect my Django app to SQL Server 2016. I've tried using django-pyodbc but it doesn't support Django 1.11. Instead I installed django-mssql 1.8. When I try to run the application I get this error.

    TypeError was unhandled by user code
    Message: 'NoneType' object is not callable


    At execute_from_command_line(sys.argv) in manage.py.

    Here is my DATABASES from settings.py:

    DATABASES = {
    'default': {
    'ENGINE': 'sqlserver_ado',
    'NAME': 'TEST2',
    'HOST': 'PCNAME\SQLEXPRESS',
    'USER': '',
    'PASSWORD': '',
    'OPTIONS' : {
    'provider': 'SQLOLEDB',
    'use_mars': True,
    },
    }
    }


    I've tried both the default and SQLOLEDB provider but always get the same error. I've also tried with and without user and password set but the error remains the same. I am able to connect to a local MySQL DB just fine.

    I'm running Windows 10, Visual Studio 2015, SQL Server Express 2016

    Edit:

    Here's the output from pip freeze:

    appdirs==1.4.3
    Django==1.11
    django-mssql==1.8
    mysqlclient==1.3.10
    packaging==16.8
    pyodbc==4.0.16
    pyparsing==2.2.0
    pytz==2017.2
    six==1.10.0


    Here's my requirements.txt:

    django==1.11
    mysqlclient==1.3.10
    django-mssql==1.8

    Continue reading...

Compartilhe esta Página