Re: anaconda python 3.5 + windows 7 + cx_Oracle 5.2?
Christopher Jones <[email protected]> Wed, 9 Nov 2016 12:03:39 +1100
| Newsgroups | gmane.comp.python.db.cx-oracle |
|---|---|
| Message-ID | <[email protected]> |
In particular, check you have correct 32 or 64 bit Oracle Client libraries. They need to match Python (and cx_Oracle). Chris On 9/11/2016 10:44 AM, Adam Kerz wrote: > 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 > _______________________________________________ > cx-oracle-users mailing list > cx-oracle-users-5NWGOfrQmneRv+LV9MX5uipxlwaOVQ5f@public.gmane.org > https://lists.sourceforge.net/lists/listinfo/cx-oracle-users > -- http://twitter.com/ghrd ------------------------------------------------------------------------------ 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