Re: anaconda python 3.5 + windows 7 + cx_Oracle 5.2?

Adam Kerz <[email protected]> Wed, 9 Nov 2016 09:44:16 +1000
Newsgroups gmane.comp.python.db.cx-oracle
Message-ID <[email protected]>
Have you installed the correct version of the Oracle client and is it on 
the path?

eg.

PATH=C:\oracle\x86-32\product\12.1.0\client_1\bin;...

That's ALWAYS been my problem when I've gotten that exception from 
cx_Oracle.

Adam


On 9/11/2016 2:14 AM, Codiga, Daniel wrote:
> To be a little more complete regarding my final comment, …
>
>
>
> When I create the environment using python 3.4, it appears that
> cx_Oracle 5.2 has been installed successfully (according to Anaconda
> Navigator, at least). Then when I try “import cx_Oracle” the problem is
> not exactly that it can’t find the win32 file; the error message is this:
>
>
>
> ImportError: DLL load failed: %1 is not a valid Win32 application.
>
>
>
>
>
>
>
> *From:*Codiga, Daniel
> *Sent:* Monday, November 07, 2016 3:55 PM
> *To:* 'cx-oracle-users-5NWGOfrQmneRv+LV9MX5uipxlwaOVQ5f@public.gmane.org'
> *Subject:* anaconda python 3.5 + windows 7 + cx_Oracle 5.2?
>
>
>
> From what I have read in the documentation, it looks like I should be
> able to install anaconda python 3.5 on my windows 7 64-bit PC and
> include cx_Oracle 5.2 in a conda virtual environment.
>
>
>
> However I am encountering problems in trying.
>
>
>
> ( Previously I was using Anaconda python 2.7 with cx_Oracle 5.1.2 in a
> conda environment without trouble. I mention this because it seems
> possible that my problems are associated with not fully/successfully
> uninstalling cx_Oracle 5.1.2? Just a thought.)
>
>
>
> Anyway I do a clean wipe of python from my system and then install
> Miniconda (64 bit windows) and all is well. I then try to create an
> environment “conda env create environment.yml” -- with “python=3.5” and
> “cx_Oracle” both listed as dependencies in the environment.yml file--
> and get the “specifications were found to be in conflict” error. It says
> “ – cx_oracle -> python 2.7*|3.4*” and “ – python 3.5*”.
>
>
>
> So then, to troubleshoot a little, I try same but with “python=3.4” in
> the environment.yml file. The environment gets created ok. But when I
> try “import cx_Oracle” I get an error saying it couldn’t find the win32
> file.
>
>
>
> Suggestions?
>
>
>
>
>
>
>
> ------------------------------------------------------------------------------
> Developer Access Program for Intel Xeon Phi Processors
> Access to Intel Xeon Phi processor-based developer platforms.
> With one year of Intel Parallel Studio XE.
> Training and support from Colfax.
> Order your platform today. http://sdm.link/xeonphi
>
>
>
> _______________________________________________
> cx-oracle-users mailing list
> cx-oracle-users-5NWGOfrQmneRv+LV9MX5uipxlwaOVQ5f@public.gmane.org
> https://lists.sourceforge.net/lists/listinfo/cx-oracle-users
>


------------------------------------------------------------------------------
Developer Access Program for Intel Xeon Phi Processors
Access to Intel Xeon Phi processor-based developer platforms.
With one year of Intel Parallel Studio XE.
Training and support from Colfax.
Order your platform today. http://sdm.link/xeonphi