title: How to use Django with Sql Server
body: <p>I normally use Postgres for my database needs with Django but I recently started at a company which use MSSQL on a Windows environment. Long story short I had to rewrite the database properties in settings.py. Unfortunately, I have NO idea how to connect to a SQL Server using Pyodbc and they're running Python 3.x so I can't use Django-Pyodbc. While trying to run it I'm getting a:
  "Data source name not found and no default driver specified (0) (SQLDriverConnect)')"</p>
  
  <p>Here is my current db config as it stands. I'm probably doing something wrong but it is very difficult to find resources since most Django+Sql Server results either use FreeTDS or Django-Pyodbc (neither are options).</p>
  
  <pre><code>'default': {
      'ENGINE': 'sql_server.pyodbc',
      'NAME': 'db_name_on_server',
      'USER': 'my_acct',
      'PASSWORD': 'nope',
      'HOST': 'x.x.x.x',
      'PORT': '1433',
      'OPTIONS': {  # Options are not edited
          'driver': 'SQL Server',  # What it displays as on odbc admin   
          'dsn': 'System DSN',  # What it displays as on odbc admin
          'use_legacy_datetime': False
      }
  </code></pre>