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

Configuring Django for Netezza database (nzSQL)

I'm fully new to Django (though not pyodbc), and I'm a little confused by how the database settings work. I would like to go the models route and configure settings.py to connect to Netezza database that has the following odbc…
Olga Mu
  • 908
  • 2
  • 12
  • 23
1
vote
1 answer

Using SQL Server backend with Django

I'm trying to connect to an external SQL Server Express database using the django-pyodbc version at: this github link but I keep getting this error when I run manage.py shell to check if I can execute come ORM commands Traceback (most recent call…
Stephen M
  • 809
  • 1
  • 10
  • 21
1
vote
0 answers

Can't load records with text fields with a length of more than 19455 characters in Django using pyodbc

I have a Note model like so (this is pulling from a legacy MS SQL Server database so most of these records were not created by Django): class Note(models.Model): id = models.AutoField(primary_key=True, db_column="note_id") content =…
Jordan Reiter
  • 20,467
  • 11
  • 95
  • 161
0
votes
1 answer

Pyodbc - Invalid connection String- Login failed for user

Im getting this error, trying to connect an external SQL Server from Django through VPN i tried different ways of formatting the string, but doesnt work. '28000', "[28000] [Microsoft][ODBC Driver 11 for SQL Server][SQL Server]Login failed for user…
Pablo Barrios
  • 23
  • 1
  • 9
0
votes
0 answers

Is there any way to connect Athena database to django

I am working to build dashboard on tables of athena. I have tried django-pyodbc in database settings but it is not working.
Jaspreet Kaur
  • 1
0
votes
1 answer

Django Application not working when moved to a app server

I have a Django app which works fine on my development machine. But when moved to a different location on app server for hosting, it does not work. The error django.core.exceptions.ImproperlyConfigured: 'django-pyodbc-azure' isn't an available…
ProgrammerInMaking
  • 23
  • 5
0
votes
1 answer

Violation of UNIQUE KEY constraint 'UQ__accounts'. Cannot insert duplicate key in object 'dbo.accounts_ouser'. The duplicate key value is ()

In my Django site I created a custom user model. I am using windows authentication, so up until now, a user was able to go directly to my site. I could also create users in the admin page and edit their permissions there as well. It seems that all…
wmoskal
  • 295
  • 1
  • 4
  • 15
0
votes
0 answers

Either paramter @objname is ambiguos or the claimed @objtype is wrong

I am trying to switch from the default Django user model to a custom user model. when I try to migrate the changes I get the error: Either the parameter @objname is ambiguous or the claimed @objtype (COLUMN) is wrong. I am using driver 13 from…
wmoskal
  • 295
  • 1
  • 4
  • 15
0
votes
0 answers

Query execution failed: \r\nTable already exists. (Tablename: django_migrations)

I have a project where i need to use django with Nexus DB. I have customized django-pyodbc package to nexusDB compactable as third party Database engine. But While making the initial migration found this error. Traceback (most recent call…
Arun Augustine
  • 1,690
  • 1
  • 13
  • 20
0
votes
1 answer

Incompatible Comparison Error from Filter Length

Question I am getting an incompatible comparison error detailed below, but it's dependent on the size of the string I'm passing to the filter. Anyone know what the cause of or solution to this error would be, or where I can dig in deeper to identify…
lengeta
  • 23
  • 4
0
votes
1 answer

Django+sql server - No module named sql_server.pyodbc.base

I want to use SQL Server as the backend for Django. I install pyodbc, django-pyodbc, django-pyodbc-azure In settings.py I replace a Database DATABASES = { 'default': { 'ENGINE': 'sql_server.pyodbc', 'NAME': 'xxx', …
Michael Podgortsev
  • 127
  • 2
  • 11
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
0 answers

SQL UPDATE does not affect any row via django-pyodbc

I have django-pyodbc installed for Python 2.7 (Ubuntu 14.04, unixODBC, FreeTDS) and I am attempting to update a SQL Server database that I created as a test. Everything works well except one particular UPDATE statement that does not affect any row.…
Patrick
  • 2,577
  • 6
  • 30
  • 53
0
votes
1 answer

Trouble using django-pyodbc with python manage.py dbshell / loaddata

I'm having trouble connecting to a SQL Server database through python manage.py dbshell / loaddata. I'm set up on Ubuntu with FreeTDS, unixODBC, pyodbc (3.0.7) and django-pyodbc from here: https://github.com/lionheart/django-pyodbc/ I can…
FlipperPA
  • 13,607
  • 4
  • 39
  • 71
1 2 3 4
5
6