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
1
vote
1 answer

Connecting to a legacy informix database with django

I'm trying to connect to an existing Informix database with Django, I'm using django-pyodbc-azure to handle the connection via odbc, the connection work fine when trying in the python interpreter: >>>import pyodbc >>>conn =…
PatrickStewball
  • 13
  • 3
1
vote
1 answer

Problems Using Django 1.11 with Sql-Server database view

I am trying to use Django (django 1.11.4) to read data from a SQL-Server view (sql server 2012 - I use sql_server.pyodbc [aka django-pyodbc] for this), and nothing seems to work. Here's my model: class NumUsersAddedPerWeek(models.Model): id =…
karlk
  • 21
  • 1
  • 6
1
vote
3 answers

django-pyodbc-azure no module named 'sql_server'

I am attempting to use a corporate SQL Server as the backend for my Django project with Python 3.5.2. I have installed Django 2.0.3, pyodbc==4.0.22, django-pyodbc-azure 2.0.3, pypiwin32==219 (pip freeze below). I have also configured DATABASES in my…
kivo
  • 11
  • 2
1
vote
0 answers

By adding one statement import pyodbc causes Internal Server Error in Apache HTTP Server

To run the normal school old python file in Apache Server. I had coded this way index.html
First Name:
Last Name:
Nɪsʜᴀɴᴛʜ ॐ
  • 2,756
  • 4
  • 33
  • 57
1
vote
1 answer

Django create a Datatable using MSSQL

Hello I am new to using Django and would like to create a datatable with data that is stored in a database of an MSSQL server. I have managed to connect Django via django_mssql but I do not know how to access a table since there are many in the…
Hugo Alain Oliva
  • 237
  • 1
  • 10
1
vote
1 answer

django-pyodbc and calling a stored procedure

I'm testing my code on Windows 10. I have a Django application that needs to call a stored procedure on a remote SQL Server database. Here's the DATABASES snippet from settings.py: DATABASES = { 'default': { 'ENGINE':…
Phil O
  • 1,588
  • 4
  • 28
  • 52
1
vote
1 answer

Django and django-pyodbc error NotImplementedError SQL Server v8 is not supported

I'm working with Django and PyODBC to connect to a SQL Server 2000 database and I'm gettinh this error: Exception Type: NotImplementedError Exception Value: SQL Server v8 is not supported. My traceback: Environment: Request Method: POST Request…
João Victor
  • 33
  • 1
  • 7
1
vote
1 answer

Update to pyodbc 4 causes "Segmentation fault"

I have a Django+celery site running on Elastic Beanstalk that used pyodbc 3. Because of another issue, I had to update to pyodbc 4. However, the web site starting giving error 500 and this is the information logged: [Fri Feb 24 20:02:14.448536…
Diego Jancic
  • 7,280
  • 7
  • 52
  • 80
1
vote
0 answers

unixODBC Driver Manager Can't open lib

I'm trying to connect to SQL Server db using django 1.10 and pyodbc, Mas Os X 10.11.5 Firstly, when I'm typing python manage.py inspectdb the traceback is ('01000', "[01000] [unixODBC][Driver Manager]Can't open lib 'FreeTDS' file not found (0)…
insomniaqq
  • 61
  • 1
  • 5
1
vote
1 answer

Django-pyodbc mssql error for dumpdata

I am trying to perform a sudo ./manage.py dumpdata on a mssql db from my django project, but keep getting: Traceback (most recent call last): File "./manage.py", line 10, in execute_from_command_line(sys.argv) File…
Philippe Fisher
  • 586
  • 7
  • 28
1
vote
1 answer

SQL Server 2008/2012 backend module for Django on Linux?

I'm new to Django and I'm working on a project that requires SQL Server to be used. I've researched extensively on using Django with SQL Server, and it seems like django-pyodbc is the way to go. On the pydobc page, it mentions that only SQL Server…
user3705002
  • 13
  • 4
1
vote
1 answer

DjangoUnicodeDecodeError: 'utf8' codec can't decode with pyodbc-azure

I use pyodbc-azure 1.1.5 to connect my django project to a SQL Server db (aberration, I know) My client is SQL Server Native Client 11.0 When I try to open the corresponding change_list I get this error: 'utf8' codec can't decode byte 0xd1 in…
toscanelli
  • 1,202
  • 2
  • 17
  • 40
1
vote
2 answers

django-pyodbc: Data source name not found, and no default driver specified

I'm using Ubuntu 12.04 server, Django 1.5.5, pyodbc-3.0.7 and I am trying to connect to a MSSQL 2005 server. I've installed django-pyodbc through pip and modified my settings.py like so: DATABASES = { 'default': { 'ENGINE':…
dan-klasson
  • 13,734
  • 14
  • 63
  • 101
1
vote
1 answer

syncdb - ValueError: too many values to unpack

UPDATE for close - I think I go through it and it was a bit of stupidity on my behalf. python manage.py inspectdb > models.py I was forgetting to pipe the output to a file! I've dumped that into my app/models.py and now I'm just trying to get it…
whoisearth
  • 4,080
  • 13
  • 62
  • 130
1
vote
1 answer

Django is doing something weird with my DATABASES settings

I want to switch db backends from django_pyodbc to sqlite in order to make sure my custom user model works before I start messing around with my db. So I commented out the DATABASES setting and put in a new one which uses sqlite. I've done this…
moarCoffee
  • 1,289
  • 1
  • 14
  • 26
1 2 3
4
5 6