title: Python-Oracle connection issue with Pyodbc
body: <p>Tried to connect to the Oracle database using Pyodbc:</p>
  
  <pre><code>try:
      db_connection = pyodbc.connect('DSN=OraDev; PWD=%s' % Key.dbKeys['password'])
  except pyodbc.Error, err:
          print &gt;&gt; debug_file, "Database connection failed: %s" %err 
          sys.exit()
  </code></pre>
  
  <p>and it keeps giving me this error message: </p>
  
  <blockquote>
    <p>'[IM014] [Microsoft][ODBC Driver Manager] The specified DSN
    contains an architecture mismatch between the Driver and Application
    (0) (SQLDriverConnect)</p>
  </blockquote>
  
  <p>So I am wondering if the culprit is that I am not having the "matching" components. Currently, I have:</p>
  
  <blockquote>
    <ol>
    <li>Python 2.7 32bit</li>
    <li>Pyodbc 3.0.6 win32-py2.7</li>
    <li>Oracle ODBC driver: 32bit</li>
    <li>Windows server 2008 64bit</li>
    <li>Oracle 11.2.0 64bit</li>
    </ol>
  </blockquote>
  
  <p>Are there anything wrong with the versions here? Thanks.</p>