title: How to connect pyodbc to an Access (.mdb) Database file
body: <p>Here's what I've tried:</p>
  
  <p>-Find Vista's ODBC Data Source Manager* through search,</p>
  
  <p>-Add a new File Data Source*, selecting Driver for Microsoft Access (*.mdb), and selecting my mdb file of interest,</p>
  
  <p>-import pyodbc from python shell and try:</p>
  
  <pre><code>pyodbc.connect("DSN=&lt;that Data Source I just created&gt;")
  </code></pre>
  
  <p>I get the following error message (Portuguese**):</p>
  
  <pre><code>Error: ('IM002', '[IM002] [Microsoft][ODBC Driver Manager] Nome da fonte de dados n\xe3o encontrado e nenhum driver padr\xe3o especificado (0) (SQLDriverConnectW)') 
  </code></pre>
  
  <p>Which translates as "Data source name not found and no standard driver specified".</p>
  
  <p>What am I doing wrong? 
  How to get it right?
  Also, I searched the web for documentation but found nothing worth much, could anyone recommend any documentation?</p>
  
  <p>*Names may not be completely accurate because my Windows is in Portuguese.</p>
  
  <p>**No, Portuguese doesn't have '3' and '\' as letters, these are misprinted special characters</p>