Comments (10)
Hi, i have the same Problem. Can anyone help me? What exactly i have to upgrade/change?
My system:
Django-2.1.15
django_pyodbc_azure-2.1.0.0
ODBC Driver 17 for SQL Server
from django-pyodbc-azure.
Hi, Please check: https://pypi.org/project/django-pyodbc-azure-2019/
My Code working with mssql 2019
pip install django-pyodbc-azure-2019
DATABASES = {
'default': {
'ENGINE': 'sql_server.pyodbc',
'NAME': 'djangotestdb',
'USER': 'sa',
'PASSWORD': '12345678',
'HOST': 'LAPTOP-MAHESH\SQLEXPRESS',
'PORT': '',
'OPTIONS': {
'driver': 'ODBC Driver 17 for SQL Server',
},
},
}
from django-pyodbc-azure.
@VarunAravinth, ty for Help. I already have had the latest Driver, but i found that django_pyodbc_azure
has a hardcoded support only for SQL lower than V15. The solution for me was, upgrade to an other package:
pip install django-mssql-backend
from django-pyodbc-azure.
Sounds like your ODBC driver is too old(?)
I'm running SQL 2017 (Windows Edition) in production with django-pyodbc-azure using the original MS-ODBC driver.
from django-pyodbc-azure.
Hi Kevin, thx for your advise, i'm using "ODBC Driver 17 for SQL Server", I can connect to the SQL server with this driver thru window ODBC settings, but django-pyodbc-azure response v15 is not supported, might be there are some different on MSSQL 2017 Linux Edition
from django-pyodbc-azure.
my stupid fault, wrongly installed preview version of MSSQL 2019 (v15), case close, sorry for your time
from django-pyodbc-azure.
Hi Guys, I am getting the same error, v15 is not supported, I am using django-mssql-backend.
Can you help me out.
File "C:\Users\VarunAravinthN\AppData\Roaming\Python\Python38\site-packages\sql_server\pyodbc\base.py", line 384, in sql_server_version
raise NotSupportedError('SQL Server v%d is not supported.' % ver)
django.db.utils.NotSupportedError: SQL Server v15 is not supported.
from django-pyodbc-azure.
Got it fixed, I upgraded my django-sql-backend. Thanks
from django-pyodbc-azure.
@s-trooper Hi, Can you check whether SQL V15 is supported by your odbc driver, (django_pyodbc_azure), if yes, check whether you are running the latest version of that driver.
That fixed my issue.
from django-pyodbc-azure.
I have the same issue, I installed and then uninstalled django-pyodbc-azure, now im using django-mssql-backend
I get the issue of odbc not supported or
raise NotSupportedError('SQL Server v%d is not supported.' % ver)
django.db.utils.NotSupportedError: SQL Server v16 is not supported.
How do I check which version is supported? Should I reinstall mssql?
from django-pyodbc-azure.
Related Issues (20)
- SQL Server Parameter Limitation HOT 1
- pyodbc.ProgrammingError: Attempt to use a closed connection.
- Django Dependency for django-pyodbc-azure 2.1.0.0 HOT 4
- problem during install on centos HOT 2
- AutoField at migration HOT 3
- with transaction.atomic() not working for Azure SQL Database HOT 2
- Django 3 HOT 2
- AttributeError: module 'django.db.models' has no attribute 'UniqueConstraint'
- Incorrect driver → Data source name not found and no default driver specified HOT 1
- Getting current connection string
- Performance killer: SQL query using nvarchar instead of char
- python manage.py migrate throws error for legacy MicrosoftSQL server database having tables in different schemas HOT 1
- django.db.migrations.exceptions.MigrationSchemaMissing: Unable to create the django_migrations table (('42000', '[42000] [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]The specified schema name "dbo" either does not exist or you do not have permission to use it. (2760) (SQLExecDirectW)')) HOT 5
- Integrated Authentication using computer name instead of remote user
- Django dependencies supported with Django 3.0.9 HOT 1
- Access model with other schema
- Why is the mars option unconditionally True in Windows?
- Microsoft now has an official 3rd Party Backend to use SQL Server with Django
- Issue with django, django rest, and django-pyodbc-azure versions HOT 1
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
D3
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
Some thing interesting about web. New door for the world.
-
server
A server is a program made to process requests and deliver data to clients.
-
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.
from django-pyodbc-azure.