[cx-oracle-users] troubleshooting cx_Oracle 64 bit gives : ImportError: DLL load failed: %1 is not a valid Win32 application.

[hari j. <ha...@gm...>]

Hi

I am trying to setup cx_Oracle with 64 bit python and 32/64 bit
instant client on a  64 bit Windows 7 machine

I have the Oracle instant client installed at :
C:\app\oracle\product\11.2.0\client_1

I have the ORACLE_HOME environment variable defined and also have the
C:\app\oracle\product\11.2.0\client_1\BIN directory in my path.
I am running Python 2.7.2 64 bit mode
WHen I import cx_Oracle I get the message " ImportError: DLL load
failed: %1 is not a valid Win32 application."

I dont know what bit-size my currently installed  Instant client
application uses.
I would prefer not switching to a 32 bit python.

How do I get the 64 bit cx_Oracle msi to work. I tried getting a fresh
64 bit instant client from Oracle, but found many installation files
at this location
(http://www.oracle.com/technetwork/topics/winx64soft-089540.html)
Which one do I need .

Thanks for your help
Hari


#Here is what I have on the command prompt on import cx_Oracle

C:\Users\harijay>cd %ORACLE_HOME%"

C:\app\oracle\product\11.2.0\client_1>


Python 2.7.2 (default, Jun 12 2011, 14:24:46) [MSC v.1500 64 bit (AMD64)] on win
32
Type "help", "copyright", "credits" or "license" for more information.
>>> import cx_Oracle
Traceback (most recent call last):
  File "<stdin>", line 1, in <module>
ImportError: DLL load failed: %1 is not a valid Win32 application.
>>>