django-pyodbc-azure 2.1.0.0 not supporting Django 2.1.0

Question

We are trying to connect Django-2.1 with MS SQL Server 2012. We were looking for modules to use for this and stumbled across django-pyodbc-azure. We pip installed it and while restarting the app, we got this following error message:

Unhandled exception in thread started by <function check_errors.<locals>.wrapper
 at 0x0000006140CB2BF8>
Traceback (most recent call last):
  File "C:\Program Files\Python36\lib\site-packages\django\utils\autoreload.py",
 line 225, in wrapper
    fn(*args, **kwargs)
  File "C:\Program Files\Python36\lib\site-packages\django\core\management\comma
nds\runserver.py", line 109, in inner_run
    autoreload.raise_last_exception()
  File "C:\Program Files\Python36\lib\site-packages\django\utils\autoreload.py",
 line 248, in raise_last_exception
    raise _exception[1]
  File "C:\Program Files\Python36\lib\site-packages\django\core\management\__ini
t__.py", line 337, in execute
    autoreload.check_errors(django.setup)()
  File "C:\Program Files\Python36\lib\site-packages\django\utils\autoreload.py",
 line 225, in wrapper
    fn(*args, **kwargs)
  File "C:\Program Files\Python36\lib\site-packages\django\__init__.py", line 24
, in setup
    apps.populate(settings.INSTALLED_APPS)
  File "C:\Program Files\Python36\lib\site-packages\django\apps\registry.py", li
ne 112, in populate
    app_config.import_models()
  File "C:\Program Files\Python36\lib\site-packages\django\apps\config.py", line
 198, in import_models
    self.models_module = import_module(models_module_name)
  File "C:\Program Files\Python36\lib\importlib\__init__.py", line 126, in impor
t_module
    return _bootstrap._gcd_import(name[level:], package, level)
  File "<frozen importlib._bootstrap>", line 994, in _gcd_import
  File "<frozen importlib._bootstrap>", line 971, in _find_and_load
  File "<frozen importlib._bootstrap>", line 955, in _find_and_load_unlocked
  File "<frozen importlib._bootstrap>", line 665, in _load_unlocked
  File "<frozen importlib._bootstrap_external>", line 678, in exec_module
  File "<frozen importlib._bootstrap>", line 219, in _call_with_frames_removed
  File "C:\Program Files\Python36\lib\site-packages\django\contrib\auth\models.p
y", line 2, in <module>
    from django.contrib.auth.base_user import AbstractBaseUser, BaseUserManager
  File "C:\Program Files\Python36\lib\site-packages\django\contrib\auth\base_use
r.py", line 47, in <module>
    class AbstractBaseUser(models.Model):
  File "C:\Program Files\Python36\lib\site-packages\django\db\models\base.py", l
ine 101, in __new__
    new_class.add_to_class('_meta', Options(meta, app_label))
  File "C:\Program Files\Python36\lib\site-packages\django\db\models\base.py", l
ine 304, in add_to_class
    value.contribute_to_class(cls, name)
  File "C:\Program Files\Python36\lib\site-packages\django\db\models\options.py"
, line 203, in contribute_to_class
    self.db_table = truncate_name(self.db_table, connection.ops.max_name_length(
))
  File "C:\Program Files\Python36\lib\site-packages\django\db\__init__.py", line
 33, in __getattr__
    return getattr(connections[DEFAULT_DB_ALIAS], item)
  File "C:\Program Files\Python36\lib\site-packages\django\db\utils.py", line 20
2, in __getitem__
    backend = load_backend(db['ENGINE'])
  File "C:\Program Files\Python36\lib\site-packages\django\db\utils.py", line 11
0, in load_backend
    return import_module('%s.base' % backend_name)
  File "C:\Program Files\Python36\lib\importlib\__init__.py", line 126, in impor
t_module
    return _bootstrap._gcd_import(name[level:], package, level)
  File "C:\Program Files\Python36\lib\site-packages\sql_server\pyodbc\base.py",
line 11, in <module>
    raise ImproperlyConfigured("Django %d.%d.%d is not supported." % VERSION[:3]
)
django.core.exceptions.ImproperlyConfigured: Django 2.1.0 is not supported.

We have tried many versions of Django such as 2.x, 2.0.4, 2.1 and all version seem to throw the same error which is

Django 2.x.x is not supported.

Database info in settings.py:

DATABASES = {
    'default': {
        'ENGINE': 'sql_server.pyodbc',
        'HOST': 'xxxxxx,1433',
        'USER': 'xxxxxxxx',
        'PASSWORD': 'xxxxxxxx',
        'NAME': 'xxxxxx',
        'OPTIONS': {
            'driver': 'ODBC Driver 17 for SQL Server',
            'host_is_server': True
        },
    }
}

Any leads would be appreciated. Thanks.

With `django-pyodbc-azure`, you need to make sure the minor version matches the Django minor version. Are you sure you're running `Django==2.1.x` and `django-pyodbc-azure==2.1.x`? Can you check in a `pip freeze`? This line indicates it should work: https://github.com/michiya/django-pyodbc-azure/blob/azure-2.1/sql_server/pyodbc/base.py#L11 — FlipperPA, Sep 04 '18 at 14:14
@FlipperPA - Thanks for your support. I have installed the `django-pyodbc-azure 2.1` from https://github.com/michiya/django-pyodbc-azure and having `django 2.1` version installed but when I do pip freeze the django-pyodbc-azure version shows `django-pyodbc-azure==1.10.0.1`. Is this expected or is there another link to django-pyodbc-azure 2.1? — Kaushik, Sep 05 '18 at 05:16

score 1 · Accepted Answer · answered Sep 05 '18 at 08:13

1

This issue resolved by downloading the wheel file of django-pyodbc-azure 2.1.0.0 from https://pypi.org/project/django-pyodbc-azure/#files and installing using the command pip install django_pyodbc_azure-2.1.0.0-py3-none-any.whl.

answered Sep 05 '18 at 08:13

Kaushik

451
1
7
22

1

To install via `pip` from GitHub, you can provide the branch: `pip install git+https://github.com/michiya/django-pyodbc-azure.git@azure-2.1` should work. It sounds like you may have installed from a different branch. Good sleuthing, I'm glad you got it working! – FlipperPA Sep 05 '18 at 09:49

score 0 · Answer 2 · answered Sep 04 '18 at 14:33

0

I had same problem few month back. The final combined version worked was python 3.5 and django 1.11 with django-pyodbc-azure latest version

answered Sep 04 '18 at 14:33

iamabhaykmr

1,199
11
33

django-pyodbc-azure 2.1.0.0 not supporting Django 2.1.0

2 Answers2