django-mssql is a SQL Server 2005/2008 backend for Django running on Windows.
https://bitbucket.org/Manfre/django-mssql
django-mssql is a SQL Server 2005/2008 backend for Django running on Windows.
Questions tagged [django-mssql]
57 questions
1
vote
1 answer
error using django-admin with django-mssql
I am using django 1.6 with django-mssql
My django admin site works perfectly except for one part.
Whenever I click an "add user" link or otherwise navigate to /admin/auth/user/add I get the following error
(-2147352567, 'Exception occurred.', (0,…
Matt
- 3,778
- 2
- 28
- 32
1
vote
1 answer
django-mssql: 'Query timeout expired' during syncdb
After syncdb creates the tables I get an error when enabling the constraints:
Installing custom SQL ...
Installing indexes ...
DatabaseError: (-2147352567, 'Exception occurred.', (0, u'Microsoft SQL Server N
ative Client 10.0', u'Query timeout…
dan-klasson
- 13,734
- 14
- 63
- 101
1
vote
2 answers
Django SQL Server Error: "Cannot create new connection because in manual or distributed transaction mode."
I have some strange issue with querying SQL Server from django.
When I query db twice in single request, I got errors in some cases. Namely when first db query returns big amount of data, we end up with error while querying db second…
Intelligent-Infrastructure
- 1,188
- 4
- 18
- 39
1
vote
1 answer
When running syncdb on Django-mssql SQLInsertCompiler error
This is on Microsoft SQL Server 2005.
Python 2.7.
Django 1.4
Django-MSSQL is installed and connecting to the database.
I can read tables, but not insert or update them. Working through django's tutorial on an empty database I get to this point:
#…
Dustin Holden
- 180
- 2
- 12
0
votes
1 answer
Django user.set_password(password) is not hashing the password
I have wrote Custom user Model in Django everything is working fine except password is not being hashed when but when I had created the superuser password was hashed here are my models for custom user and custom user manager
model.py()
class…
Abdullah Moudood
- 23
- 5
0
votes
0 answers
How do I solve the problem of " 'mssql' isn't an available database backend or couldn't be imported" on windows?
I ran into this problem when trying to deploy some django project on a Windows 10 computer.
Every time I try to access localhost, it displays this error:
Error occurred while reading WSGI handler:
Traceback (most recent call last):
File…
XINYANG YU
- 3
- 4
0
votes
1 answer
Docker ubuntu 20 unable to install msodbcsql17 or 13 SQL SERVer odbc Driver 13 or 17
unfortunately I'm a bit desperate.
I have created a dockerimage and am running everything with docker-compose.
If i run docker-compose up i get this error:
| django.core.exceptions.ImproperlyConfigured: 'mssql' isn't an available database backend or…
Paddymaster
- 70
- 1
- 10
0
votes
0 answers
Connecting to MSSQL from django 1.8 on Ubuntu
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…
xralf
- 3,312
- 45
- 129
- 200
0
votes
2 answers
How to execute raw sql statement for SQL server from django?
Original db query that works:
SELECT *
FROM [db_name].[dbo].[table]
WHERE name IN (
SELECT name
FROM [db_name].[dbo].[table]
WHERE active = 1
Group by name
Having count(*) > 1
)
order by name
and when I try to execute it from django as
from…
David Louda
- 498
- 5
- 19
0
votes
1 answer
AttributeError: module 'six' has no attribute 'memoryview' occurs when configuring django database for django-mssql
My Django is the latest version, python3.8. I want to configure the database for sql server 2008 R2, so I install django-mssql(aka,sqlserver_ado). After running the server, an error occurs:
.........
File "", line…
vainquit
- 491
- 6
- 13
0
votes
1 answer
Handling multiple database in Django
I am developing a web-application in Django using MySQL database. Now, I need to connect to an internal SQL Server Database and update only 1 table ClientDetails
Here is my Database configuration:
DATABASES = {
'default': {
'ENGINE':…
Kiran
- 8,034
- 36
- 110
- 176
0
votes
3 answers
unable to connect to mssql database from Django app from a docker container
I am new to docker containers and I have been struggling to connect to mssql database from Django app and successfully launch docker container for my rest API. Please bear with me for long question.
Here is my docker file
FROM ubuntu:19.04
ENV…
Tanzeel Ur Rahman
- 51
- 7
0
votes
1 answer
Error on inspectdb model creation django
I am using django with mssql. I already have a existing database and want to create django model for the tables in that database.
I followed this django book instruction for inspectdb.
http://django-book.readthedocs.io/en/latest/chapter18.html
When…
user5586747
0
votes
0 answers
django migrate error : 'Microsoft OLE DB Provider for SQL Server', "Cannot insert the value NULL into column 'last_login', table
I have installed below versions
Django==1.8
django-mssql==1.8
pypiwin32==220
pytz==2017.3
and my setting.py file is as below.
----------------Start of setting.py------------------
INSTALLED_APPS = (
'django.contrib.admin',
…
praveen shet
- 1
- 2
0
votes
1 answer
python3.6.2 + django1.11.4 + django-mssql1.8 - is this combination supports? Unable to connect sql server from django
I am using pthon3.6.2 + django1.11.4 + django-mssql1.8 combination for my web application and unable to connect to sql server database. Following is the setting I am using in setting.py
DATABASES = {
'default': {
'NAME': 'DB1',
…
Devasish
- 1,917
- 2
- 22
- 32