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.

49 questions
12
votes
5 answers

Django python 'sql_server.pyodbc' isn't an available database backend

I'm trying to connect my Django app to microsoft sql database on apache server but I get the following error messages: django.core.exceptions.ImproperlyConfigured: 'sql_server.pyodbc' isn't an available database backend. Try using…
Mack
  • 343
  • 2
  • 5
  • 12
10
votes
4 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
  • 141
  • 2
  • 2
  • 7
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
  • 13,607
  • 4
  • 39
  • 71
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,604
  • 4
  • 20
  • 36
4
votes
1 answer

django-mssql-backend - Invalid connection string attribute (0)

OK, I'm slowly going crazy. I want to connect Django 3 to MSSQLv15 Server. Connection works if I use Trustedconnection=yes (using win credentials), it also works on Ubuntu if I'm using FreeTDS v7.4 but it won't work in Windows if I manually insert…
Jennosian
  • 185
  • 1
  • 8
4
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
  • 2,324
  • 1
  • 27
  • 75
4
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
  • 2,324
  • 1
  • 27
  • 75
3
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
  • 185
  • 1
  • 8
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
  • 553
  • 3
  • 11
  • 27
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,338
  • 8
  • 42
  • 66
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
  • 3,325
  • 9
  • 34
  • 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
  • 893
  • 6
  • 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
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
  • 2,197
  • 3
  • 25
  • 40
2
votes
1 answer

How to fix pyodbc dependency errors when upgrade Django from 2.1 to 2.2.13?

Since version 2.1 has been marked as insecure I need to upgrade at least to >=2.2. Github security suggests installing 2.2.13. I also need to install other packages that only work with Django >=2.2. The Django upgrade is successful but when pipenv…
Danna Capellan
  • 107
  • 6
1
2 3 4