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
0
votes
0 answers
Poor performance of db. inserts using django-mssql
I designed data warehousing application, but I struggle with poor performance when fetching data from the source and saving them to db. - only approximately 150 kB/s.
Because of the limitations imposed by the customer, I am forced to use Django on…
Mr. Napik
- 5,499
- 3
- 24
- 18
0
votes
1 answer
Unable to connect to MSSQL database via django-mssql
I'm trying to connect to my Microsoft SQL Server database from django but I am getting the following error when running the web server using django-mssql
PS N:\Documents\Python> python .\manage.py check
Traceback (most recent call last):
File…
Danny Cullen
- 1,782
- 5
- 30
- 47
0
votes
1 answer
Django MSSQL Database Backend vs. Django PYODBC
I'm new at both Python and Django and still trying to figure out the best environment for my development. As far as I saw, there are 2 options available for establishing a connection to a MSSQL database which are:
Django MSSQL Database Backend:…
Phyticist
- 566
- 1
- 8
- 20
0
votes
0 answers
django connection.cursor.execute() returns None
In the python shell (python 2.7, django 1.6, Windows 8), I'm trying to execute a simple query against one of my table in SQL Server 2008 (engine=django_mssql):
connection.cursor.execute("SELECT * from mymodel_mytable")
The result is None. The…
Patrick
- 2,577
- 6
- 30
- 53
0
votes
1 answer
django inspectdb AttributeError: 'unicode' object has no attribute 'type'
Hi I'm getting an AttributeError while using inspectdb.
Platform OS: Windows
Django Version: 1.7
Database: MS-SQL 2008
Please help me. Thanks.
ERROR:
from django.db import models
Traceback (most recent call last):
File "manage.py", line 10, in…
Greatxam Darthart
- 158
- 1
- 15
0
votes
1 answer
Python/Django - Connecting to a legacy SQL Server Databse getting error "AttributeError: 'module' object has no attribute 'sqlserver_ado'"
So I'm connecting my Django app to a SQL server database using django-mssql and pywin32-218.win-amd64-py2.7
Everything works great if I'm starting from scratch by creating models and syncing the database.
However, I'd like to connect to an existing…
PercivalMcGullicuddy
- 5,263
- 9
- 46
- 65
0
votes
1 answer
Hitting error when installing django-mssql 1.5
No clue as to what the problem is - any suggestions appreciated.
Python 3.3.1 (32-bit), Django 1.6.2, Win7 professional.
Here is the traceback:
Running setup.py egg_info for package django-mssql
Traceback (most recent call last):
File…
Steve Sawyer
- 1,785
- 4
- 18
- 21
0
votes
0 answers
Accessing rowset after committing a transaction
I have a problem with django and msssql (stored procedure):
com_error at /add_client/
(-2147352567, 'Ocurri\xf3 una excepci\xf3n.', (0, u'Microsoft SQL Server Native
Client 10.0', u'The object is in a zombie state. An object may enter a zombie…
Samuel Cusi
- 11
- 1
0
votes
3 answers
MSSQL Permissions not making sense in MSSQL2008
I create the database in Management Studio. Added a SQL authenticated user to the list of users for the DB.
I set up (granted) the permissions like so:
use DjangoDB;
grant select,insert,update,alter,delete,references to django;
select
a.*,
…
boatcoder
- 17,525
- 18
- 114
- 178
0
votes
1 answer
Send email on trigger failure
I have successfully configured and able to sent email using 'Database mail' on SQL server 2008 R2 by calling msdb.dbo.sp_send_dbmail stored procedure.
And I can catch the failure of a query in a trigger by putting it in try-catch block.
But What I…
mili
- 3,502
- 1
- 29
- 29
0
votes
1 answer
How to write ms sql code for two column with same datas in MS SQL
Here it two table.
Table1
SchoolID Teacher_name comm_yr
01 John 1990
02 Heley 1995
03 George 1994
04 Chris 1998
05 Mary 1993
Table2
School_ID …
user1355061
- 83
- 9
-2
votes
2 answers
django-mssql on debian linux
Anyone has success on install django-mssql on linux machine? My deploy server is debian linux and I cant deploy my applications made on windows machine.
I have troubes on my legacy latin1 database on acess it from pyodbc on django, Anyone has a…
Manuel
- 1
- 1