Stack Overflow
Stack Overflow

Questions tagged [django-pyodbc-azure]

This is a deprecated tag for a Python package that is no longer maintained.

The django-pyodbc-azure package is no longer maintained.

Please use django-mssql-backend instead; it supports Django 2.2 and above.

48 questions
8
votes
2 answers

django-pyodbc-azure rollback error with previously working configuration - line 389

I've been using django-pyodbc-azure for a while on Linux, along with pydobc, FreeTDS and unixODBC to connect Django to SQL Server 2014. I ran into this problem with an application that had been working fine, and am having trouble debugging it. To…
FlipperPA
  • 11,339
  • 3
  • 27
  • 57
7
votes
3 answers

How to use Django with Sql Server

I normally use Postgres for my database needs with Django but I recently started at a company which use MSSQL on a Windows environment. Long story short I had to rewrite the database properties in settings.py. Unfortunately, I have NO idea how to…
Will.Beasley
  • 111
  • 2
  • 2
  • 6
5
votes
2 answers

Attempting to connect to MSSQL with django-pyodbc-azure results in file not found error

I think my question is more or less a duplicate of Trying to query SQL Server from django running on Linux - Can't open lib '/path/to/libtdsodbc.so', but the answer there is wholly not useful. I am using the following things: Ubuntu…
Mitch
  • 1,434
  • 2
  • 14
  • 33
3
votes
2 answers

django-pyodbc-azure 2.1.0.0 not supporting Django 2.1.0

We are trying to connect Django-2.1 with MS SQL Server 2012. We were looking for modules to use for this and stumbled across django-pyodbc-azure. We pip installed it and while restarting the app, we got this following error message: Unhandled…
Kaushik
  • 451
  • 1
  • 7
  • 22
3
votes
2 answers

Django 2.1 SQL Server 17 error - isn't an available database backend. Try using 'django.db.backends.XXX'

django.core.exceptions.ImproperlyConfigured: 'django-pyodbc-azure' isn't an available database backend. Try using 'django.db.backends.XXX', where XXX is one of: 'mysql', 'oracle', 'postgresql', 'sqlite3' I have tried switching to the following…
Loser Coder
  • 2,148
  • 7
  • 38
  • 63
3
votes
1 answer

Accessing Existing Data in a SQL Server Table with Django

I have django connected to SQL Server with django-pyodbc-azure. I am brand new to django. I created a model in django models.py, and I was able to migrate the model to SQL Server. All the proper tables are created. I have historical data that will…
OverflowingTheGlass
  • 1,949
  • 19
  • 55
3
votes
0 answers

django-pyodbc-azure is checking version on every request

Issue on GitHub: https://github.com/michiya/django-pyodbc-azure/issues/80 Every time a request is made, the django-pyodbc-azure backend is checking for the SQL version, resulting in a lot of additional latency: QUERY = "SELECT…
aensm
  • 2,685
  • 9
  • 26
  • 44
3
votes
0 answers

Django: 'unicode' object has no attribute 'tzinfo'. Production server only

I'm stumped. With my local set up (python manage.py runserver) everything runs fine. With my production set up (wsgiserver.CherryPyWSGIServer), I get 'unicode' object has no attribute 'tzinfo' when my program tries to convert datetime2(7) from the…
BottleZero
  • 833
  • 5
  • 13
3
votes
3 answers

django-pyodbc-azure - How to use schemas

I'm using django-pyodbc-azure (https://github.com/michiya/django-pyodbc-azure) and everything is working fine. However, when I migrate the models, a new schema called 'dbo' is created on the SQL Server database. I want to use an already existing…
ikermdagirre
  • 53
  • 1
  • 5
2
votes
1 answer

[FreeTDS][SQL Server]Login failed for user

I am developing on a windows and trying to run the Django application in Linux container with Gunicorn and Nginx to deploy it to Linux machine in production. I mostly used this Connect docker python to SQL server with pyodbc post as a guide but I…
Jennosian
  • 55
  • 6
2
votes
1 answer

Can't connect to MSSQL using django-pyodbc-azure 2.1.0.0

As the title says. Im getting this error django.db.utils.InterfaceError: ('IM002', '[IM002] [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified (0) (SQLDriverConnect)') Heres my code DATABASES = { 'default':…
Daniele Sto Domingo
  • 64
  • 8
2
votes
1 answer

django-pyodbc-azure SQL Server Parameter Limitation

Django: 1.11 I am using django-pyodbc-azure as my Django backend. It is connecting to SQL Server 2012. SQL Server has a limit of 2,100 parameters. When I attempt to use prefetch_related on a queryset that will return more than 2,100 results... def…
OverflowingTheGlass
  • 1,949
  • 19
  • 55
2
votes
1 answer

Django Hive connectivity

DATABASES = { 'default': { 'ENGINE': 'sql_server.pyodbc', 'NAME': 'sampletest', 'OPTIONS': { 'driver': '/opt/cloudera/hiveodbc/lib/64/libclouderahiveodbc64.so', 'dsn': 'Hive1', …
Ripundeep Gill
  • 169
  • 1
  • 16
2
votes
1 answer

How to set up Django Azure website to access database

I am trying to set up my Django site using Azure Websites (not an Azure VM). I got a site with some static pages up and running, and I created an Azure SQL Database, but how do I connect the Django site to use the Azure db?
Hat
  • 1,597
  • 5
  • 26
  • 41
1
vote
0 answers

pyodbc error "SystemError: returned a result with an error set"

I was developing a reporting dashboard using Django. I'm pulling data from an outer database (ms SQL server 2012) using django-pyodbc-azure. I was facing a weird problem when I pulling data in my localhost using manage.py runserver it can pull the…
Antu
  • 1,611
  • 2
  • 20
  • 31
1
2 3 4