title: Django-pyodbc SQL Server/freetds server connection problems on linux
body: <blockquote>
    <p>Error: ('IM002', '[IM002]
    [unixODBC][Driver Manager]Data source
    name not found, and no default driver
    specified (0) (SQLDriverConnectW)')</p>
  </blockquote>
  
  <p>I'm migrating from developing on a windows development machine to Linux machine in production and I'm having issues with the freetds driver. As far as I can tell that error message means it can't find the driver. I can connect via the cli via sqsh and tsql.  I've setup my settings.py as such.</p>
  
  <pre><code>   'bc2db': {
          'ENGINE': 'sql_server.pyodbc',
          'NAME': 'DataTEST',
          'USER': 'appuser',
          'PASSWORD': 'PASS',
          'HOST': 'bc2.domain.com',
          'options': {
              'driver': 'FreeTDS',
              }
      },
  </code></pre>
  
  <p>Does anyone have any SQL Server experience with django? do I have to use a dns? (how would I format that?) </p>