No module named sqlserver_ado.base

1,255 views
Skip to first unread message

MWH1711

unread,
Jan 30, 2018, 3:34:56 PM1/30/18
to QATrack+
I was trying to run "winpty python manage.py syncdb" after creating local_settings.py file. And this is the error message I got:

django.core.exceptions.ImproperlyConfigured: 'django_pyodbc' 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 django_pyodbc.base


Did I miss something during the deploying process?

 (QATrack+ with IIS, CherryPy and SQL Server)

Thank you

Meng Wei

Randle Taylor

unread,
Jan 31, 2018, 10:11:46 AM1/31/18
to MWH1711, QATrack+
Sounds like you are either missing or have an incorrect version of either django-mssql (or pywin32) installed.  If you do `winpty pip freeze` what packages do you see?

Thanks,
Randy

--
You received this message because you are subscribed to the Google Groups "QATrack+" group.
To unsubscribe from this group and stop receiving emails from it, send an email to qatrack+unsubscribe@googlegroups.com.
To post to this group, send email to qat...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

Meng Wei Ho

unread,
Jan 31, 2018, 10:32:03 AM1/31/18
to Randle Taylor, QATrack+
These are the packages. Thank you.

$ winpty pip freeze
backports.functools-lru-cache==1.4
cheroot==6.0.0
CherryPy==13.1.0
colorama==0.3.9
coverage==4.4.2
cycler==0.10.0
Django==1.6.11
django-admin-views==0.5.0
django-braces==1.4.0
django-debug-toolbar==0.11
django-listable==0.3.10
django-nose==1.4.2
django-pyodbc==0.2.8
django-tastypie==0.9.16
EasyProcess==0.2.3
funcsigs==1.0.2
logilab-astng==0.24.3
logilab-common==1.4.1
matplotlib==2.1.2
mimeparse==0.1.3
mock==2.0.0
more-itertools==4.1.0
nose==1.3.7
numpy==1.13.3+mkl
pbr==3.1.1
pep8==1.7.1
portend==2.2
pydicom==0.9.9
pylint==0.28.0
pyodbc==3.0.10
pyparsing==2.2.0
pypiwin32==219
python-dateutil==2.2
python-ntlm==1.1.0
pytz==2014.7
PyVirtualDisplay==0.2.1
pywin32==220
scipy==1.0.0
selenium==2.53.6
six==1.11.0
South==1.0.1
sqlparse==0.2.4
tempora==1.10

Randle Taylor

unread,
Jan 31, 2018, 10:42:00 AM1/31/18
to Meng Wei Ho, QATrack+
I don't see django-mssql in that list which is required.  You can install like so:  `winpty pip install django-mssql==1.6.2` and then try the syncdb command again.


Meng Wei Ho

unread,
Jan 31, 2018, 2:49:51 PM1/31/18
to Randle Taylor, QATrack+
Thank you. It works. 
I had one issue when installing CherryPy in win.txt, so I installed latest version which gave me an importerror message. Then I reinstalled CherryPy with 'pip install "cherrypy>=3.0.8,<9.0.0" '

jun.j...@gmail.com

unread,
Jun 5, 2018, 10:04:34 PM6/5/18
to QATrack+
same problem with:
astroid==1.6.4
autopep8==1.3.5
colorama==0.3.9
Django==2.0.6
django-mssql==1.8
isort==4.3.4
lazy-object-proxy==1.3.1
mccabe==0.6.1
pycodestyle==2.4.0
pylint==1.9.1
pytz==2018.4
six==1.11.0
virtualenv==16.0.0
virtualenvwrapper-win==1.2.5
wrapt==1.10.11

Randle Taylor

unread,
Jun 15, 2018, 11:53:20 AM6/15/18
to jun.j...@gmail.com, QATrack+
Hello,

Apologies for the slow response, this email fell way down my inbox!

It doesn't look like you have the correct package versions installed (QATrack+ doesn't use Django 2).  Which installation directions are you following?

Randy

--
You received this message because you are subscribed to the Google Groups "QATrack+" group.
To unsubscribe from this group and stop receiving emails from it, send an email to qatrack+u...@googlegroups.com.
Reply all
Reply to author
Forward
0 new messages