Stack Overflow
Stack Overflow

Questions tagged [django-mssql]

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.

57 questions
21
votes
5 answers

ImportError: No module named pythoncom

I am a newbie (just 1 week) to this Python world. I tried installing django-mssql, but when I tried to import the library (using import sqlserver_ado.dbapi), I got this error message: ImportError: No module named pythoncom I tried to look for that…
Quaspam
  • 263
  • 1
  • 3
  • 6
11
votes
2 answers

Django - How to prevent database foreign key constraint creation

I have a model that is backed by a database view. class OrgCode(models.Model): org_code = models.CharField(db_column=u'code',max_length=15) org_description = models.CharField(max_length=250) org_level_num …
Joe Petrini
  • 489
  • 1
  • 3
  • 12
8
votes
5 answers

Connecting Django with MSSQL server

I'm trying to connect my Django app to SQL Server 2016. I've tried using django-pyodbc but it doesn't support Django 1.11. Instead I installed django-mssql 1.8. When I try to run the application I get this error. TypeError was unhandled by user…
user1424311
  • 417
  • 1
  • 6
  • 17
5
votes
1 answer

django-pyodbc vs django-mssql

It's in the title really. I want to run Django against MSSQL 2005. Both look reasonably active and up to date. I can't seem to see any unique points for either. Can anyone recommend one over the other? Would it be trivial to swap between the two…
Joe
  • 46,419
  • 33
  • 155
  • 245
5
votes
1 answer

Trouble connecting to MS SQL Server with django-mssql

I'm trying to use django-mssql to connect to MS SQL Server 2008 R2 with Django 1.4.2 These are my Database settings: DATABASE_ENGINE = 'sqlserver_ado' DATABASE_NAME = 'dbtest' DATABASE_USER = 'App' DATABASE_PASSWORD =…
lurknobserve
  • 230
  • 3
  • 13
4
votes
6 answers

Setting up django-mssql issues

I'm having some issues setting up django-mssql on Win Server 2008 R2. I have everything installed, however, the wiki for django-mssql says to setup the settings file similar to: DATABASES = { 'default': { 'NAME': 'my_database', 'ENGINE':…
rjbez
  • 802
  • 2
  • 12
  • 21
4
votes
3 answers

pywintypes27.dll not found using Apache, Django, pywin32, Python2.7 and mod_wsgi

I have a Django application using django-mssql to communicate w/ SQL Server. This works just fine in the dev server (runserver) but under Apache/mod-wsgi, I get a error related to it trying to find a .dll which does exist: Exception Type:…
Terry
  • 533
  • 7
  • 17
4
votes
4 answers

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 of confirm_password and same i am migrating, but i am…
Ronak
  • 187
  • 2
  • 17
4
votes
4 answers

Establishing connection to MS SQL Server 2014 with django-mssql-1.6

i am aware that the django-mssql-1.6/README states: SQL Server Versions Supported Versions: 2008 2008r2 2012 but, seeing as v. 1.6 is the latest version available, i was wondering if anyone was able to find a way to connect to an MS SQL Server…
scagnetti
  • 1,435
  • 3
  • 20
  • 38
3
votes
3 answers

Django. Database query: distinct for one field

I have following fields and data in DB: FirstName LastName Date John          Davis       10-10-2011 Joe           Gray        20-09-2011 Ann           Davis       03-04-2010 Ann           Bovis       01-04-2010 How can I select from DB 3…
sunprophit
  • 1,639
  • 4
  • 16
  • 39
3
votes
2 answers

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 execute_from_command_line(sys.argv) File "C:\Program…
elvainch
  • 1,369
  • 3
  • 15
  • 32
3
votes
1 answer

SQL Server Filestream with django-mssql

I would like to use SQL Server Filestream feature to store files (mainly large images) from a Django application. Currently I am using django-mssql as the database backend for my Django project. I don't think there is any existing model field in…
rparent
  • 630
  • 7
  • 14
3
votes
1 answer

Query timeout expired in django-mssql when executing custom SQL directly

I am querying a view which will return huge data and takes more than 1 minute to complete. I am executing the query with django.db.connection.cursor() since this is not my default db. After 30 seconds I am getting an exception 'Query timeout…
shinoymm
  • 315
  • 1
  • 3
  • 10
3
votes
1 answer

Error "sqlserver_ado isn't an available database backend" (PyISAPIe on IIS)

I'm having problems connecting my Django project to SQL Server 2008 when using IIS to serve Django and django-mssql to handle transactions. I am using IIS 7 and 64 bit ActivePython 2.7. Here is my list of installed…
turtlemonvh
  • 9,149
  • 6
  • 47
  • 53
3
votes
1 answer

How can I connect to SQL Server 2008 R2 with django-mssql?

I cannot figure out why I cannot get django to connect with sql server 2008 r2. I have administrative privileges on our server and on sql server. I have constructed a virtual windows box with windows server 2008 sp2 because I thought I might have…
Justin O Barber
  • 11,291
  • 2
  • 40
  • 45
1
2 3 4