why python manage.py sql polls has error?

Question

I use django .

I create in this file models.py my model like this :

from django.db import models

class Poll(models.Model):
    question = models.CharField(max_length=200)
    pub_date = models.DateTimeField('date published')

class Choice(models.Model):
    poll = models.ForeignKey(Poll)
    choice_text = models.CharField(max_length=200)
    votes = models.IntegerField(default=0)

And I change this file settings.py like this

INSTALLED_APPS = (
    'django.contrib.admin',
    'django.contrib.auth',
    'django.contrib.contenttypes',
    'django.contrib.sessions',
    'django.contrib.messages',
    'django.contrib.staticfiles',
    'polls',
)

And I change mu database on SQL Server 2012

DATABASES = {
    'default': {
        'NAME': 'DjangoFirst',
        'ENGINE': 'sqlserver_ado',
        'HOST': 'PCClient',
        'USER': 'sa',
        'PASSWORD': 'sa',
    }
}

When I execute this command in Command prompt

python manage.py sql polls

I get this error :

django.core.exceptions.ImproperlyConfigured: 'sqlserver_ado' isn't an available
database backend.
Try using 'django.db.backends.XXX', where XXX is one of:
    u'mysql', u'oracle', u'postgresql_psycopg2', u'sqlite3'
Error was: No module named sqlserver_ado.base

What is(are) wrong ?

not yet?your answer is about postgresql, but i want connect to sql server. and i found my answer in this post stackoverflow.com/questions/20265854/… — Ardalan Shahgholi
– Ardalan Shahgholi, Commented Nov 28, 2013 at 17:48

greg · Accepted Answer · 2013-11-28 12:57:36Z

1

You should to select needed backend module (see all availible modules in comment line). Correct this line:

ENGINE = 'postgresql_psycopg2' # 'postgresql_psycopg2', 'postgresql', 'mysql', 'sqlite3' or 'oracle'

answered Nov 28, 2013 at 12:57

greg

1,41610 silver badges28 bronze badges

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

2 Comments

Ardalan Shahgholi Over a year ago

I want use SQL Server 2012 for my database?!?

greg Over a year ago

Maybe to try this version of mssql backend?

bruno desthuilliers · Accepted Answer · 2013-11-28 13:01:38Z

1

The error message seems quite explicit: your default database settings are asking for a django database backend that cannot be found - either it does not exist or is not installed or you don't pass the correct python qualified name to your backend.

answered Nov 28, 2013 at 13:01

bruno desthuilliers

78.3k6 gold badges103 silver badges129 bronze badges

Comments

Grijesh Chauhan · Accepted Answer · 2013-12-12 05:52:33Z

1

Finally I found the answer.

I most use from an another version of Django that support SQL Server 2012 and load that in my Python.

I think django-mssql 1.4rc2 is a good for my purpose.

This is "Python: Package Index > django-mssql" of version of Django that support SQL Server 2005 and later.

However , I can not use Django 1.6 and connect to SQL Server 2012 yet.

edited Dec 12, 2013 at 5:52

Grijesh Chauhan

58.6k20 gold badges145 silver badges214 bronze badges

answered Nov 28, 2013 at 17:56

Ardalan Shahgholi

12.7k25 gold badges116 silver badges155 bronze badges

1 Comment

Manfre Over a year ago

The next version of django-mssql will support Django 1.6 and Django 1.7. bitbucket.org/Manfre/django-mssql

Collectives™ on Stack Overflow

why python manage.py sql polls has error?

3 Answers 3

2 Comments

Comments

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

2 Comments

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related