Stack Overflow
Stack Overflow

Questions tagged [django-pyodbc]

A 3rd-party database backend for Django that uses ODBC to query Microsoft SQL Server. The typical driver stack is django-pyodbc -> pyodbc -> unixodbc -> freetds on Linux.

A 3rd-party database backend for Django that uses ODBC to query Microsoft SQL Server. The typical driver stack is django-pyodbc -> pyodbc -> unixodbc -> freetds on Linux.

As for 5/2014, this fork is most active maintained: https://github.com/lionheart/django-pyodbc/

85 questions
0
votes
3 answers

Cannot connect to legacy database using django-pyodbc

I have installed django-pyodbc and configured my database settings as: DEV: Windows XP (64bit), Python 3.3, MDAC 2.7 DB: Remote MSSQL 2008 DATABASES = { 'default': { 'ENGINE': 'django_pyodbc', 'HOST': 'my.server.com', …
user2225394
  • 25
  • 1
  • 1
  • 3
0
votes
1 answer

django-pyodbc DatabaseError message is wired

I use django-pyodbc on Django 1.6.1 when I run manage.py syncdb, everything is fine. I use 2 database setttings in Django to read some data from my legacy database, when I what to read the data from a model name T_AllStation: all_t_station =…
GoTop
  • 850
  • 1
  • 9
  • 22
0
votes
1 answer

Patching a bug in django-pyodbc

I'm trying to patch this bug and am running into problems. django-pyodbc is an SQL Server backend to django, and the bug causes any sql to be converted to a bytes type in python 3.x, which raises a TypeError when it is attempted to be executed (must…
aidan
  • 33
  • 1
  • 5
0
votes
1 answer

Unable to provide % wildcards in cursor.execute query

I'm interfacing with SQL Server from Django using django-pyodbc. I'm trying to build a query with optional parameters around a stored procedure which I'll pass to cursor.execute. I'm constructing the query manually so that I only provide SP…
DanH
  • 5,498
  • 4
  • 49
  • 72
0
votes
2 answers

How to run Django on Windows and cope with Apache not having a daemon mode?

Evolution of this question This started as an attempt to find other recommendations for running Django on Linux, accessing SQL Server via Django-PyODBC, and supporting Unicode as competently as in installations running Django on Windows. After…
cethegeek
  • 6,286
  • 35
  • 42
0
votes
1 answer

How can i connect Remote MS access using pyodbc

How can i connect to remote MS Access DB using pyodbc, before i can able to connect to MS SQL server using pyodbc via freetds. But if i use the same freetds configuration for remote access, 'i'm not getiing the success. Any suggestions?
Asif
  • 1,775
  • 4
  • 25
  • 39
0
votes
1 answer

Django pyodbc Stored Procedure Error - not all arguments converted during string formatting

I have a django function that calls a stored procedure in SQL Server 2008, via pyodbc as follows: def new_user(self): # create a cursor cur = connection.cursor() try: cur.execute("{CALL sp_newPerson (?,?,?,?,?)}", …
Muniu
  • 187
  • 1
  • 2
  • 15
0
votes
1 answer

Custom Django binary field & SQL Server 2008

I have a little table: CREATE TABLE [organization_division] ( [id] int IDENTITY (1, 1) NOT NULL PRIMARY KEY, [uuid] binary(16) NOT NULL ) I can insert a record with SQL query: INSERT INTO [organization_division] ([uuid]) VALUES…
art.zhitnik
  • 604
  • 5
  • 19
-1
votes
1 answer

pyodbc session error when django project is downloaded from gitlab

i have a django project which works fine when not uploaded i have uploaded it to gitlab with following command: 1. git clone ssh://git@gitlab****dcms-api.git 2. git checkout dcms_sso 3.git add . then i took the same code from git lab: 1. git clone…
geek
  • 794
  • 3
  • 16
  • 41
-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
1 2 3 4 5
6