title: Python Access Database Query Giving "Data Source Name Not Found"
body: <p>Whenever I attempt to query a file using Python script, I receive the following error </p>
  
  <blockquote>
    <p>pyodbc.InterfaceError: ('IM002', u'[IM002] [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified (0) (SQLDriverConnect)')</p>
  </blockquote>
  
  <p><a href="https://i.stack.imgur.com/fbsnp.png" rel="nofollow noreferrer">Image of Error Message</a></p>
  
  <p>My code is as followings:</p>
  
  <pre><code>conn = pyodbc.connect ("DRIVER={ODBCDataFile [Microsoft Access Driver 
  (*.mdb, *.accdb)]};DBQ=C:\Users\jmtr\Documents\IRST_old.accdb;")
  
  cur = conn.cursor()
  cur.execute("SELECT Name, CAI, Email, SSPLocation, BUNUM from Tbl_SSP")
  </code></pre>
  
  <p>My Access database is "Microsoft Access 2016 32-bit".  I am also using "32-bit" python 2.7.13 and 32-bit PYODBC. And, I have 32-bit drivers set-up in the ODBC Data Source Administrator: </p>
  
  <p><a href="https://i.stack.imgur.com/Wehn8.png" rel="nofollow noreferrer">Image of ODBC 32-bit</a></p>
  
  <p>I don't understand why I am still receiving this error message? </p>