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
2
votes
3 answers

Django - Insert Without Returning the Id of the Saved Object

Each time the save() method is called on a Django object, Django executes two queries one INSERT and one SELECT. In my case this is usefull except for some specific places where each query is expensive. Any ideas on how to sometimes state that no…
Siavash
  • 358
  • 1
  • 5
  • 19
2
votes
1 answer

django-mssql not working in Apache w/ mod-wsgi, but works fine in dev server

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 fail related to it trying to find a .dll which does exist: [Thu May 19 15:35:09 2011]…
sdcharle
  • 156
  • 8
2
votes
1 answer

Calling a Stored Procedure using django-mssql

I'm trying to call a stored procedure on a multi-database project I am working with. I have 2 of my stored procedures working, but this particular stored procedure is not working and returns an error: Traceback (most recent call last): File…
Jan Wilmar
  • 157
  • 4
  • 12
2
votes
2 answers

Django and SQL Server 2005 - Zombie status?

I'm using Django 1.2 and django-mssql. While performing the following for unicorn in Unicorn.objects.all(): print unicorn.color I'm getting the following error at around the 100th iteration: com_error: (-2147352567, 'Exception occurred.', (0,…
RadiantHex
  • 24,907
  • 47
  • 148
  • 244
2
votes
1 answer

django-pyodbc-azure. Invalid object name 'django_session'

I need help with setting up my project. I used django-pyodbc-azure and I have this in my settings.DATABASES: DATABASES = { 'default': { 'ENGINE': 'sql_server.pyodbc','NAME': 'DBNAME','USER': 'USER', 'PASSWORD': 'PASSWORD', …
Jan Wilmar
  • 157
  • 4
  • 12
2
votes
1 answer

Django query to join records of two tables

I am using django-mssql 1.6.2 package with django 1.7 to get one or several records of tables from sql server 2008. When I call "get" or "filter" as follows, everything is fine but my server program is very slow. Consider the following tables: class…
Happy Ahmad
  • 1,072
  • 2
  • 14
  • 33
2
votes
2 answers

django-mssql - Invalid connection string attribute

This is the error I am getting when I run the django web server. django.db.utils.OperationalError: (com_error(-2147352567, 'Exception occurred.', (0, u'Microsoft OLE DB Provider for SQL Server', u'Invalid connection string attribute', None, 0,…
Danny Cullen
  • 1,782
  • 5
  • 30
  • 47
2
votes
0 answers

Operand type clash: ntext is incompatible with decimal

I looked at previous questions with the same problem but they all seem to be due to custom queries built by the person. However my problem is with django giving me this error. In my model I have 2 decimal fields for storing Longitude and…
john
  • 3,949
  • 7
  • 34
  • 56
2
votes
0 answers

Error: App 'consistency' has migrations. Only the sqlmigrate and sqlflush commands can be used when an app has migrations

I have created an app titled "consistency" in Django. When I run python manage.py sql consistency I get this error: App 'consistency' has migrations. Only the sqlmigrate and sqlflush commands can be used when an app has migrations. What can I…
Prav001
  • 343
  • 1
  • 5
  • 12
1
vote
2 answers

How To Download django-mssql On Windows

I can't download django-mssql from Google Code there doesn't seem to be a direct download link and the svn wont work for me. Anybody know a direct download link?
Siavash
  • 358
  • 1
  • 5
  • 19
1
vote
2 answers

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 than 3 arguments are passed in. The first 2…
Loser Coder
  • 2,338
  • 8
  • 42
  • 66
1
vote
0 answers

How is pywintypes loaded differently via WSGI in Django 1.7?

After upgrading from Django 1.6 to 1.7, all was fine in dev when using the built-in runserver. However, after deploying on Apache with mod_wsgi, an error occured when django-mssql was used: Traceback (most recent call last): ... File…
user193130
  • 8,009
  • 4
  • 36
  • 64
1
vote
1 answer

Unable to migrate django database using django-mssql

I am trying to migrate my django database to MS SQL Server 10.50.2500 using django-mssql. When I try to run python manage.py migrate I get this error: django.db.utils.OperationalError: (com_error(-2147352567, 'Exception occurred.', (0,…
George
  • 343
  • 2
  • 15
1
vote
2 answers

Error connecting to SQL Server 2008 with Django

I am using django-mssql and SQL Server 2008, but I found that it always errors when I do some commands,for example: python manage.py syncdb the error is below: raise OperationalError(e, "Error opening connection: " + connection_string)…
august
  • 45
  • 9
1
vote
2 answers

"no module named pythoncom"

I am trying to build a test Django application and I want to connect to a MSSQL server. When I tried running my program I get an error ImportError: No module named pythoncom. So I figured it's a missing module so I downloaded pywin32(32bit) for…
john
  • 3,949
  • 7
  • 34
  • 56
1
2
3 4