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
– Frane, Commented Jan 8, 2018 at 11:02
Would love to know how you resolve this... would rather not downgrade... — Matthew Clark
– Matthew Clark, Commented Jan 18, 2018 at 21:36

Ryan · Accepted Answer · 2018-04-27 02:38:52Z

12

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',
        },
    }
}

answered Apr 27, 2018 at 2:38

Ryan

2341 gold badge4 silver badges7 bronze badges

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

1 Comment

Rann Lifshitz Over a year ago

good formatting on your answer. Welcome to StackOverflow buddy :)

Pavan Rajput · Accepted Answer · 2019-05-15 10:46:22Z

0

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', }

answered May 15, 2019 at 10:46

Pavan Rajput

373 bronze badges

Collectives™ on Stack Overflow

Using Sql Server with Django 2.0

2 Answers 2

1 Comment

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related