59 questions
- Bountied 0
- Unanswered
- Frequent
- Score
- Trending
- Week
- Month
- Unanswered (my tags)
0
votes
1
answer
53
views
Django and django-mssql - problem with rendering ForeignKey field in ModelForm
In my Django application I would like to use 2 databases. First (default one) - sqlite3 and second MS SQL.
Since Django don't support MsSQL I'm forced to use 3rd party django-mssql package.
I have ...
0
votes
1
answer
142
views
Get raw SQL query for further execution in database client
How am I able to retrieve the produced plain SQL statement from a Django ORM query which I can use in another database client program?
For example, having a ModelA.objects.filter(name='abc') queryset. ...
1
vote
0
answers
357
views
Dockerized Django App - Login timeout connecting to SQL Server Database ODBC Driver 17
I'm trying to connect my Django application, running in a container, to a SQL Server.
I've read many different topics but none of the provided solutions works in my case, can you please help me with ...
0
votes
1
answer
153
views
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 ...
0
votes
1
answer
2k
views
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....
0
votes
0
answers
355
views
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 ...
0
votes
2
answers
2k
views
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 ...
4
votes
4
answers
4k
views
Keyerror 'include' on migrating models to sql server
I have a django application and have backend as Microsoft sql server. For that, i have installed "pip install django-mssql-backend".
I have extended User model and added one additional field ...
0
votes
1
answer
432
views
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:
..........
0
votes
1
answer
41
views
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:
...
0
votes
3
answers
1k
views
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.
...
1
vote
2
answers
3k
views
Django execute stored procedure - different data types, multiple parameters and different columns from model
Here is a list of what works and what doesn't, along with the errors. when trying to send in an decimal/money data type variable. I'm not sure if the issue is with different data types, or that more ...
3
votes
2
answers
3k
views
Error connecting Django 2.0 with sql server 2014 using python 3.6
I am new in Django and I am trying to connect it with Sql server. As I read there is a third party connector for this.
Traceback (most recent call last):
File "manage.py", line 15, in <module>
...
0
votes
1
answer
799
views
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-...
user avatar
user5586747
0
votes
0
answers
417
views
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------------------
...