Using sql server on django

Question

I have got following in my django env

Django==1.8.1
django-mssql==1.6.2
django-pyodbc==0.2.8
pyodbc==3.0.10
pywin32==219 
sql-server.pyodbc==1.0

and the following in my settings.py

DATABASES = {
  'default': {
    'NAME': 'db_name',
    'ENGINE': 'sqlserver_ado',
    'HOST': 'host_name\\SQLEXPRESS',
    'USER': 'user_name',
    'PASSWORD': 'password',
  }
}

But when I try to migrate it I face the following error. Am I missing out something?

django.core.exceptions.ImproperlyConfigured: 'sqlserver_ado' isn't an available database backend.
Try using 'django.db.backends.XXX', where XXX is one of:
'base', 'mysql', 'oracle', 'postgresql_psycopg2', 'sqlite3'
Error was: cannot import name 'BaseDatabaseWrapper'

I am using sql server 2012 but there they mention as 2005/2008. Though I tried it. I get the same error. I have the complete sqlserver_ado folder in /site-packages/ — Kiran Kumar
– Kiran Kumar, Commented May 5, 2015 at 12:19

isaaclw · Accepted Answer · 2015-05-12 03:05:48Z

1

I had been using django 1.8, and solved it by downgrading to django 1.6. These are the libraries installed in my virtualenv after the downgrade, and when I got it working.:

(env)$ pip list
argparse (1.2.1)                                         
Django (1.6)                                             
django-pyodbc (0.2.8)                                    
pip (1.5.4)                                              
pyodbc (3.0.10)                                          
setuptools (2.2)                                         
wsgiref (0.1.2)

answered May 12, 2015 at 3:05

isaaclw

97210 silver badges23 bronze badges

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

Comments

HiroshiFuu · Accepted Answer · 2015-05-05 12:34:58Z

1

You need to install the python package django-sqlserver.

answered May 5, 2015 at 12:34

HiroshiFuu

3211 gold badge2 silver badges8 bronze badges

2 Comments

Kiran Kumar Over a year ago

I installed django-sqlserver, still it is not working.

HiroshiFuu Over a year ago

then install django-mssql also.

Will · Accepted Answer · 2015-12-29 06:23:02Z

1

Try using django-pyodbc instead.

In settings.py, replace the ENGINE setting with this:

'ENGINE': 'django_pyodbc',

edited Dec 29, 2015 at 6:23

Will

24.8k14 gold badges100 silver badges111 bronze badges

answered Dec 29, 2015 at 3:49

Sergey Kuzmenko

111 bronze badge

Comments

Dheeraj Inampudi · Accepted Answer · 2018-04-05 06:06:58Z

1

Try these settings with Django version 1.8.

DATABASES = {
'default': {
    'ENGINE': 'sqlserver_ado',
    'NAME': '',
    'USER': '',
    'PASSWORD': '',
    'HOST': '',
    'PORT': '1433',
     'OPTIONS': {
        'provider': 'SQLOLEDB', #SQLNCLI11 , SQLOLEDB
        'use_legacy_date_fields': 'True',
        #'extra_params' : 'DataTypeCompatibility=80;MARS Connection=True',
        #'connect_timeout': 0
        }
}

}

answered Apr 5, 2018 at 6:06

Dheeraj Inampudi

1,46717 silver badges13 bronze badges

Comments

M.Shaikh · Accepted Answer · 2018-07-11 19:37:15Z

0

For Django Version 1.11 I am using this settings:

DATABASES = {
   'default': {
       'NAME': 'DbName',
       'ENGINE': 'sql_server.pyodbc',
       'HOST': 'localhost',
       'PORT': '1433',
       'USER': 'DBUser',
       'PASSWORD': 'Db password',
       'OPTIONS': {
                    'driver': 'ODBC Driver 13 for SQL Server'
                  }
    }
}

answered Jul 11, 2018 at 19:37

M.Shaikh

2501 gold badge4 silver badges14 bronze badges

Comments

abhishek Singh · Accepted Answer · 2018-11-29 05:38:58Z

After Lost of Searching in django docs and i think most of the link in Google regarding Django with MSSQL Server below are my Configurations.

My python version is

Python 3.7.0 (v3.7.0:1bf9cc5093, Jun 27 2018, 04:59:51) [MSC v.1914 64 bit (AMD64)]

Required Packages are :

django==1.11.16

django-pyodbc-azure==2.1.0.0

pyodbc=4.0.24

pywin32==224

All Above packages are the latest one At the time of posting this post.

For Downloading pywin32 use this link (Latest version is 224)

https://github.com/mhammond/pywin32/releases

After that you need to download SQL SERVER driver, i am currently on windows 10 so i downloaded the latest one that 2017 SQL SERVER DRIVER.

https://www.microsoft.com/en-us/download/details.aspx?id=56567

After that in Django Settings.py file this is my Configuration

if you did not mention your driver version in option field this will not work so be attentive .

DATABASES = {
    'default': {
        'NAME': 'abc', #this is your database name
        'ENGINE': 'sql_server.pyodbc',  #this is your Engine 
        'HOST': 'x.x.x.x',  #MSSQL SERVER ip
        'USER': 'user',  # username
        'PASSWORD': 'password', # password 
        'OPTIONS': {         # mention your Driver Version
            'driver': 'ODBC Driver 17 for SQL Server' # Mine Driver version is 2017 so that i mentioned 17 , mention According to yourself 
        }
    }
}

lwin · Accepted Answer · 2019-09-20 04:37:55Z

0

If u add an option like :

'OPTIONS': {
                    'driver': 'ODBC Driver 13 for SQL Server'
                  }

U have to make sure u already install OCBC Driver 13 for SQL Server. (This would be inside Administrative Tools> Data Source OCBC and when u click Add button this driver should be in the list otherwise u have to install)

If still not working, try to install: pip install django-pyodbc-azure

answered Sep 20, 2019 at 4:37

lwin

4,5086 gold badges31 silver badges50 bronze badges

Collectives™ on Stack Overflow

Using sql server on django

7 Answers 7

Comments

2 Comments

Comments

Comments

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

7 Answers 7

Comments

2 Comments

Comments

Comments

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest