Connecting to MSSQL from django 1.8 on Ubuntu

269 views Asked by At

I need to connect to MSSQL database from Django 1.8 and preserve Django 1.8 (not upgrade to newer version od Django).

I installed pip install django-mssql . ENGINE in settings.py is sqlserver_ado.

It ended with error message ModuleNotFoundError: No module named pythoncom.

According to this page I see that django-mssql needs PyWin32.

So I returned back to my snapshot in virtual machine and tried it with pip install django-mssql-backend and changed the ENGINE in settings.py to sql_server.pyodbc Now I have error message sql_server.pyodbc isn't an available database backend.

So I returned back to my snapshot in virtual machine and tried it with pip install mssql-django and ENGINE is mssql. This upgraded Django to 3.4.1.

So I returned to my snapshot of virtual machine. How can I connect to MSSQL from Django 1.8 without upgrading Django? Or is it impossible? Why?

Django 1.8 is running on Ubuntu 18.04

0

There are 0 answers