Hi All, I am trying to connect to SQL server 2012 using Pyodbc and DJango framework but the version of Django is 2.1. Now, when I try to connect using below code when I only have Pyodbc installed then the below code doesnot run.
DATABASES = { 'default': { # 'ENGINE': '{ODBC Driver 11 for SQL Server}', Tried this as well but it did not work. 'ENGINE': 'sql_server.pyodbc', 'NAME': 'MY_DATABASE', # 'HOST': 'XXX.XX.XXX.XXX', Tried this as well but it did not work. 'SERVER': 'XXX.XX.XXX.XXX', # 'HOST': 'SQLSERVER_InstanceName', 'PORT': '', 'USER': 'SQLSERVERUSER', 'PASSWORD': 'USER's PASSWORD', 'DATABASE': 'MY_DATABASE', # 'Trusted_Connection': 'Yes', # 'OPTIONS': { # 'driver': 'ODBC Driver 11 for SQL Server', # } }, } But when I install django-pyodbc-azure and try to run the above code by running python manage.py inspectdb command, it works. But the problem with using django-pyodbc-azure is that it downgrades the current version of django to 2.0.8 version - which I do not want. I do not want to use FreeTDS or Pymssql. I want to go with pyodbc only. Can someone please suggest some way for this? Thanks, Gurmeet Kaur -- You received this message because you are subscribed to the Google Groups "Django users" group. To unsubscribe from this group and stop receiving emails from it, send an email to django-users+unsubscr...@googlegroups.com. To post to this group, send email to django-users@googlegroups.com. Visit this group at https://groups.google.com/group/django-users. To view this discussion on the web visit https://groups.google.com/d/msgid/django-users/CAEbKJVinxbK8KMVdUH74kxkGC%3DNv1FCU3H4B9w7HYznM8-DQLg%40mail.gmail.com. For more options, visit https://groups.google.com/d/optout.