Using Sql Server with Django 2.0

Question

I would like to use Django 2.0 with legacy MS SQL Server database.

Latest information regarding usage Django with MS SQL Server i could find is Using Sql Server with Django in production/These days and it is about Django 1.11 Most supported seems django-pyodbc-azure but it's not supporting Django 2.0 yet: django-pyodbc-azure issue #124

Is there any alternative?

I tried `pip install django-pyodbc-azure` but it want's to downgrade Django to 1.11, so I canceled it. — Frane, Jan 08 '18 at 11:02
Would love to know how you resolve this... would rather not downgrade... — Matthew Clark, Jan 18 '18 at 21:36

score 12 · Accepted Answer · answered Apr 27 '18 at 02:38

Found the solution and post it if anyone facing same problem.

I used django-pyodbc-azure 2.0.4.1 in my Django 2.0.4

The settings that worked for me:

DATABASES = {
    'default': {
        'ENGINE': 'sql_server.pyodbc',
        'NAME': 'dbName',
        'USER': 'yourUserName',
        'PASSWORD': 'yourPassword',
        'HOST': '(local)',
        'PORT': '',
        'OPTIONS': {
            'driver': 'ODBC Driver 11 for SQL Server',
        },
    }
}

good formatting on your answer. Welcome to StackOverflow buddy :) — Rann Lifshitz, Apr 27 '18 at 02:42

score 0 · Answer 2 · answered May 15 '19 at 10:46

I was facing same error of ODBC Driver Manager

django.db.utils.InterfaceError: ('IM002', '[IM002] [Microsoft][ODBC Driver Manag er] Data source name not found and no default driver specified (0) (SQLDriverCon nect)')

Solution: When i added below code in database connection, then my error fixed.
'OPTIONS': { 'host_is_server': True, 'driver': 'ODBC Driver 11 for SQL Server', }

Using Sql Server with Django 2.0

2 Answers2

Linked