title: Why do I not have ODBC Driver 17 in my pyodbc drivers? How can I fix this in anaconda?
body: <p>I keep getting this error when trying to connect to SQL server through pyodbc:</p>
  <pre><code>pyodbc.InterfaceError: ('IM002', '[IM002] [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified (0) (SQLDriverConnect)')
  </code></pre>
  <p>This is the string I am passing through pyodbc.connect():</p>
  <pre><code>'DRIVER={ODBC Driver 17 for SQL Server};'
  </code></pre>
  <p>When I run print(pyodbc.drivers()), this is what is returned:</p>
  <pre><code>['SQL Server', 'Microsoft Access Driver (*.mdb, *.accdb)', 'Microsoft Excel Driver (*.xls, *.xlsx, *.xlsm, *.xlsb)', 'Microsoft Access Text Driver (*.txt, *.csv)']
  </code></pre>
  <p>How can I get the ODBC driver 17 to appear in my list of pyodbc drivers? For reference, I am running anaconda on windows on my work machine.</p>
  <p>Many thanks</p>