Linux + Django + SQLServer

Question

I am writing a Django application which needs to intereact with a SQLServer Database. I use the Django MSSQL Backend ADO.

I am trying to use it in a Linux machine (CentOS 6.4), but for the moment I am not able to establish the connection.

Anyone has suceeded on it or knows if it is possible to connect to django-mssql from a Linux environment?

Note: I've found this question but it is quite old. I am looking for an up-to-date answer.

Edit: The error I am receiving is the following. Remark that it is a Linux machine.

django.core.exceptions.ImproperlyConfigured: 'sqlserver_ado' isn't an available database backend.

Edit 2: PyWin32 is a requirement for the django-mssql package. But is possible any workaround for Linux?

Do you have django-mssql installed? Can you import sqlserver_ado from Django shell? — Bibhas Debnath, Mar 24 '14 at 11:28
I have django-mssql installed. But nott sqlserver_ado, as it's part of the PyWin32 suite and, to my knowledge, it is not available for Linux. — Miquel, Mar 24 '14 at 11:46
If you've read the django mssql documentation, the package is called django mssql but the module is named sqlserver_ado. Recheck of you have it installed. — Bibhas Debnath, Mar 24 '14 at 12:05
I will sugget to use https://github.com/michiya/django-pyodbc-azure to connect to MS SQL Server. right now i am using it with django 2.0 and SQL Server 2008 — Ajinkya Bhosale, Mar 28 '18 at 06:30

score 7 · Answer 1 · edited Oct 24 '15 at 11:07

7

Django-MSSQL only works on Windows, hence the pywin32 dependency (Actually, anything ADO is Windows dependent since it's built on Microsoft's ActiveX).

Try Django-SQLServer. It's based on Django-MSSQL but can pass info using python-tds which is not platform specific.

edited Oct 24 '15 at 11:07

justinsg

738
6
11

answered Nov 05 '14 at 19:03

dbJones

762
1
10
31

score 1 · Answer 2 · answered Mar 28 '18 at 06:50

I will suggest to use django-pyodbc-azure instead of Django-MSSQL

Supports Django 2.0.3
Supports Microsoft SQL Server 2008/2008R2, 2012, 2014, 2016, 2017 and Azure SQL Database
Compatible with Micosoft ODBC Driver for SQL Server, SQL Server Native Client, and FreeTDS ODBC drivers

Linux + Django + SQLServer

2 Answers2