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
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…
Paul Greene
  • 63
  • 8
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,…
Phyticist
  • 566
  • 1
  • 8
  • 20
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
  • 5
0
votes
0 answers

pyodbc is not working on mac but working on windows

I am a new macbook user. I am trying to running my django project (which I created on windows machine) on my new macbook pro m2. Everything is working but while connecting to azure sql server, I am getting the following error: raise…
Abdullah Anwar
  • 1
0
votes
0 answers

Migrate from FreeTDS driver to MSODBC17 driver

I needed to change our sql driver from FreeTDS to msobdc17 for msi support. The problem results in a degradation in our insertion operations. Specifically, when we insert in bulk (with batch size~=50), the performance is highly degraded on…
Yoni Mantzur
  • 42
  • 8
0
votes
1 answer

Getting error converting data type nvarchar to numeric while saving django form to mssql database

I'm using django-pyodbc-azure with mssql and i have set some fields as foreign key in my models.py: class Production(models.Model): date = models.CharField(max_length=10, null=True) dateGr = models.DateField(auto_now=False,…
Hadi Waheed
  • 25
  • 8
0
votes
0 answers

Django 3.0.5 connection trouble to sql server 2012

I am trying to connect Django 3.0.5 to SQL server 2012 and I went through lots of posts on various websites. they mostly said that use "django-pyodbc-azure" but when I go to download that i found out it supports only django 2.1 so is there any other…
yash kumar
  • 9
  • 7
0
votes
3 answers

Django database connection with Host and Instances with SQL Server

I'm using SQL Server as the backend for the database. In the setting.py file, I need to use the host name with instance. Due to this, I got the error given below: The above exception (('08001', '[08001] [Microsoft][SQL Server Native Client 11.0]TCP…
Venugopal srinivasan
  • 145
  • 1
  • 10
0
votes
0 answers

Install msodbcsql17_17.4.2.1-1.deb driver for django SQL Server connection?

I am trying to connect django with SQL Server database using pip3 install django-pyodbc-azure. But when I install driver msodbcsql17_17.4.2.1-1.deb it produce following error: Selecting previously unselected package msodbcsql17. (Reading database…
ArunKumar
  • 179
  • 1
  • 1
  • 11
0
votes
0 answers

django migrate subquery returned more than 1 value

I'm using Django and SQL Server to create a simple django model as: from django.db import models class Person(models.Model): first_name = models.CharField(max_length = 40) last_name = models.CharField(max_length = 40) class Meta: …
sulav_lfc
  • 772
  • 2
  • 14
  • 34
0
votes
0 answers

Django database tables being created under incorrect schema

I created a Django application and connected it to SQL Server with a trusted connection. When I migrate, Django is creating a new schema name (trusted connection username) in the database and adding this on all tables as prefix. By my IT department…
Thiago Araujo
  • 149
  • 2
  • 14
0
votes
3 answers

unable to connect to mssql database from Django app from a docker container

I am new to docker containers and I have been struggling to connect to mssql database from Django app and successfully launch docker container for my rest API. Please bear with me for long question. Here is my docker file FROM ubuntu:19.04 ENV…
Tanzeel Ur Rahman
  • 51
  • 7
0
votes
0 answers

Django: "settings.DATABASES is improperly configured" upon migrate, but can access database through ORM

I'm having trouble migrating my database and creating authentication tables to my application's database for superusers, staff, etc. which has to be done by performing python manage.py migrate. I believe my problems are occuring because I'm using…
dmcoding
  • 332
  • 4
  • 18
0
votes
1 answer

Django MSSQL server on docker container won't migrate

UPDATE: Solved I am using macOS, Django 2.0 on a virtualenv, and a Docker Container with the SQL Server 2017 up and running. I'm trying to use this package: https://github.com/michiya/django-pyodbc-azure This is my DATABASES settings.py…
Fjallbacka
  • 474
  • 4
  • 16
0
votes
0 answers

Django 1.11 Unable to Connect SQL Server Express 2012 with django-pyodbc-azure

FYI, I am just getting back into programming after not coding for a few years. My programming lingo might be off; so, I hope this does not off-put anyone in the community Technologies I am using for this issue: Windows 7 Pro 64-bit Python…
progxtechy
  • 43
  • 1
  • 1
  • 5
1 2
3
4