How can i connect my default database to mssql database in django in django 3.1 as it is showing me this error. ‘django.core.exceptions.ImproperlyConfigured: Django 3.1.0 is not supported.’
Is the current version not yet compatible with mssql ?
This is my current Database connection code on which i am getting the above error:
DATABASES = {
‘default’: {
‘ENGINE’: ‘sql_server.pyodbc’,
‘NAME’: ‘testdb’,
‘HOST’: ‘localhost\MSSQLSERVER01’,
‘PORT’: ‘’,
‘OPTIONS’: {
‘driver’: ‘SQL Server Native Client 11.0’
}
}
}
According to the project page at https://pypi.org/project/django-mssql-backend/,
Django 3.1 is not listed as a supported platform.
Ohh i see, Is there any alternate way for it??
First, verify that you’re on the most current release. (2.8.1)
You might want to install from the source release from out on github.
<potentially dangerous idea>
[Disclaimer: try this at your own risk. If this destroys your database, server, peace of mind, sleep patterns, or anything else, don’t blame me.]
If those don’t work, you can chase down where the error is being thrown, modify the source where it’s checking the version to have it check against 3.1 instead of 3.0, and just try it. It’s possible that it may work “well enough” for you until the next release.
(Note, the issues tracker on github shows at least one specific Django 3.1-related error in that library - see https://github.com/ESSolutions/django-mssql-backend/issues/63)
</potentially dangerous idea>