title: Python Problems Connecting to Oracle (cx_Oracle and Pyodbc)
body: <p>Using Python 3.4 to connect to Oracle 11 (64 bit) but I can't seem to get a connection no matter what I try. I've tried both the cx_Oracle package and the pyodbc package with no success.</p>
  
  <p>Attempts with cx_Oracle</p>
  
  <pre><code>conn = cx_Oracle.connect('username/password@server')
  </code></pre>
  
  <p>and</p>
  
  <pre><code>        oradsn = cx_Oracle.makedsn(host, port, server)
          conn = cx_Oracle.connect(user="username, password=password, dsn=oradsn")
  </code></pre>
  
  <p>Error: Unable to acquire Oracle environment handle</p>
  
  <hr>
  
  <p>Attempts with pyodbc</p>
  
  <pre><code>conn = pypyodbc.connect('DRIVER={ORACLE ODBC DRIVER};DBQ=dsn name;UID=username;PWD=password')
  </code></pre>
  
  <p>and</p>
  
  <pre><code>conn = pyodbc.connect('DSN=dsn;SERVER=server;UID=username;PWD=password')
  </code></pre>
  
  <p>Error: Specified driver could not be loaded due to system error 1114: A dynamic link library (DDL) initialization routine failed.   (&lt;---- sqora32.dll is in that location, I've checked)</p>
  
  <hr>
  
  <p>Environment Variable:</p>
  
  <pre><code>ORACLE_HOME = C:\Oracle\Ora11_x64
  </code></pre>
  
  <hr>
  
  <p>Any suggestions?</p>
  
  <p>Thanks</p>