django odbc connection to production SQL server 2014 from windows machine

[AliSajah]

I have build a django project on windows 10 which i want to connect to a production SQL server however am getting the errors below when running the migrate.

Below is my database settings;

DATABASES = {

'default': { 'ENGINE': "sql_server.pyodbc", 'HOST': "127.0.0.1", 'PORT': '1433', 'USER': "student", 'PASSWORD': "XXXXXXX", 'NAME': "database_name", 'OPTIONS': { 'driver': 'ODBC Driver 13 for SQL Server', 'unicode_results': True,

    },

}

}

I have the following lib installed; Django==2.1.1 django-crispy-forms==1.7.2 django-mssql==1.8 django-pyodbc==1.1.3 django-pyodbc-azure==2.1.0.0 anaconda-client==1.6.0 anaconda-navigator==1.5 anaconda-project==0.4.1

Below are a the errors its throwing when i run the migrate.

File "C:\Python36\lib\site-packages\django\db\utils.py", line 89, in exit raise dj_exc_value.with_traceback(traceback) from exc_value File "C:\Python36\lib\site-packages\django\db\backends\base\base.py", line 216, in ensure_connection self.connect() File "C:\Python36\lib\site-packages\django\db\backends\base\base.py", line 194, in connect self.connection = self.get_new_connection(conn_params) File "C:\Python36\lib\site-packages\sql_server\pyodbc\base.py", line 307, in get_new_connection timeout=timeout) django.db.utils.InterfaceError: ('IM002', '[IM002] [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified (0) (SQLDriverConnect)')

Need help on how to go about fixing this issue.Other databases are not an option only SQL SERVER

[dlo]

Dupe of #46.

As I mentioned in the previous issue you commented on, please ask this on StackOverflow and post question URL in a follow-up comment.