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

Why isn't Django connecting to SQL Server 2019?

Please see below screenshots as to existing configuration (password hidden due to security reasons). Databases Screenshot 1 Python Packages The error that is returned when I attempt to run the server is either SQL Server v15 is not supported or…
1
vote
1 answer

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
  • 125
  • 1
  • 4
  • 10
1
vote
0 answers

CANNOT connect to SQL Server from Django on Heroku

My website will just load an existing table (brand) from SQL server and display to index page. I'm able to run the website on my machine without any problem, but it seems like the table doesn't exist when I deploy the project to Heroku. (The deploy…
Lazywii
  • 101
  • 1
  • 4
1
vote
1 answer

Django 2.0+ and SQL Server interface question

Why is it necessary to have both Pyodbc and django-pyodbc-azure installed to interface with recent SQL Server versions with Django? Why can't django just use Pyodbc out of the box? I'm having trouble getting Sql Server to play nice with python…
Jasonca1
  • 2,404
  • 3
  • 16
  • 27
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 =…
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…
1
vote
1 answer

Introspection Bug - Looks for django_migrations at the Database Level Instead of Schema Level

Update 6: After discussing the issue on the IRC #django, I think django-pyodbc-azure is introspecting the database and looking for django_migrations at the database level, not the schema level. Therefore, it's finding it at the database level (from…
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:
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…
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
  • 6,605
  • 6
  • 46
  • 76
1
vote
1 answer

Django: 'unicode' object has no attribute 'tzinfo' error using django-pyodbc-azure

I have been asked to create a simple web front-end for an internal MSSQL database. I'm using django-pyodbc-azure . I finally got everything configured and running but now when I try to log in to the admin page I get a 'unicode' object has no…
1
vote
1 answer

Django 1.9 Upgrade "Not Supported" issue

I've been using Django 1.8.7 in my project, after the yesterday's release I have upgraded to 1.9 (I am using VS PVTS and have deleted Django 1.8.7 from my Virtual Environment and installed the packages from the requirements.txt again). However,…
1
vote
3 answers

Getting server error upon publishing django application to azure

I am trying to publish my django app to azure with a MSSQL server. I am using django-azure-pyodbc with pyodbc to connect and while it works locally, whenever I publish with mssql I get an internal server error although the publish succeeds. If I…
Jason
  • 33
  • 3
0
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…