title: How to install pyodbc 64-bit?
body: <p>I have Python 2.7, MySQL 5.5, MySQL ODBC Connector 5.1, and pyodbc all installed on my computer, which is running Windows 7, 64-bit... </p>
  
  <p>Only problem is that everything is installed as 64-bit except pyodbc, which is 32-bit. </p>
  
  <p>When using easy_install to download pyodbc, it automatically downloads the 32-bit version.
  Thus, when I try to connect to my database using:</p>
  
  <pre><code>cnxn = pyodbc.connect('DRIVER={MySQL ODBC 5.1 DRIVER};SERVER=localhost;DATABASE=test;UID=root;PWD=password')
  </code></pre>
  
  <p>I get the error:</p>
  
  <pre><code>Data source name not found and no default driver specified (0) (SQLDriverConnect)
  </code></pre>
  
  <p>And when I try to specify a DSN with:</p>
  
  <pre><code>cnxn = pyodbc.connect('DSN=dsn_name;etc...')
  </code></pre>
  
  <p>I get the error:</p>
  
  <pre><code>The specified DSN contains an architecture mismatch between the Driver and Application (0) (SQLDriverConnect)
  </code></pre>
  
  <p>This link tells me that this is due to the 32/64-bit mismatch, as expected:
  <a href="http://msdn.microsoft.com/en-us/library/windows/desktop/ms712362(v=vs.85).aspx" rel="noreferrer">http://msdn.microsoft.com/en-us/library/windows/desktop/ms712362(v=vs.85).aspx</a></p>
  
  <p>So I have two questions:</p>
  
  <p>1) Is it possible to force easy_install to download the 64-bit pyodbc, or is it possible to download the 64-bit pyodbc manually?</p>
  
  <p>2) If the above is not possible, is it possible to configure the DSN to allow for this using the Microsoft ODBC Data Source Administrator window.</p>
  
  <p>Thanks.</p>