How to connect Sqlserver 2008 in Django?

Question

DATABASES = {
    'default': {
    'NAME': 'CVH_Dev',
    'ENGINE': 'sqlserver_ado',
    'HOST': '127.0.0.1',
    'USER': '',
    'PASSWORD': '',
    'OPTIONS': {
        'provider': 'SQLOLEDB',
        'use_legacy_date_fields': 'True'
    }
}

I was tried above code . but it shows error message.

Error Messgae: File "C:\Python27\lib\site-packages\django\db\utils.py", line 134, in load_backend raise ImproperlyConfigured(error_msg) django.core.exceptions.ImproperlyConfigured: 'sqlserver_ado' isn't an available database backend. Try using 'django.db.backends.XXX', where XXX is one of: 'mysql', 'oracle', 'postgresql', 'sqlite3' Error was: No module named util

please tell me how to connect SQL server 2008 to my django project.. now I m using SQL server2008R2

Назар Топольський · Accepted Answer · 2016-11-22 08:23:45Z

1

Django doesn't support MSSql out of the box. I would suggest trying an external package, like django-mssql.

answered Nov 22, 2016 at 8:23

Назар Топольський

1,13311 silver badges19 bronze badges

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

3 Comments

Amitkumar Satpute Over a year ago

yes, i already installed django-mssql, but it dosen't work. Can you tell me how to use it..

Назар Топольський Over a year ago

Are you sure you have set up your environment properly? Error message suggests that django-mssql is not found in the sys.path. Make sure to double check that by using pip list.

Amitkumar Satpute Over a year ago

yes i installed. see this Django (1.10.3) django-mssql (1.6.2) django-sqlserver (1.7) pip (9.0.1) pyodbc (3.0.10) setuptools (20.10.1) sql-server.pyodbc (1.0)

Shashishekhar Hasabnis · Accepted Answer · 2016-11-23 08:12:13Z

0

From the code that I see you are trying to use third party package Django MSSQL which needs these settings. To make these settings available for Django you first need to:-

pip install django-mssql

For further reference you can read:- http://django-mssql.readthedocs.io/en/latest/quickstart.html

edited Nov 23, 2016 at 8:12

answered Nov 22, 2016 at 8:50

Shashishekhar Hasabnis

1,7941 gold badge19 silver badges38 bronze badges

1 Comment

Amitkumar Satpute Over a year ago

i want to connect with sql server

Collectives™ on Stack Overflow

How to connect Sqlserver 2008 in Django?

2 Answers 2

3 Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

3 Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related