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

[Anthony T. <ant...@gm...>]

You need to find out whether your Oracle client is 32-bit or 64-bit.
Everything must be 64-bit or everything must be 32-bit -- you cannot
mix and match. It looks to me like your Oracle client is 32-bit --
they are completely different. Sometimes the 64-bit client also has
32-bit libraries but they will be in an alternative directory. You can
generally find out (on Windows) by running SQL*Plus and then looking
at task manager and seeing if a little *32 exists behind the
application name. Also, on Windows do *not* set the environment
variable ORACLE_HOME. That almost always causes problems. Only set the
PATH environment variable.

Anthony

On Sat, Nov 5, 2011 at 8:01 AM, hari jayaram <ha...@gm...> wrote:
> 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.
>>>>
>
> ------------------------------------------------------------------------------
> RSA(R) Conference 2012
> Save $700 by Nov 18
> Register now
> http://p.sf.net/sfu/rsa-sfdev2dev1
> _______________________________________________
> cx-oracle-users mailing list
> cx-...@li...
> https://lists.sourceforge.net/lists/listinfo/cx-oracle-users
>