Re: [cx-oracle-users] DLL load failed

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

Glad you got everything worked out. :-)

On Fri, Apr 14, 2017 at 10:03 AM, Dominique DEXHEIMER <
dom...@to...> wrote:

> I have cx_Oracle operational on my machine. The only remaining action was
> to set PATH via control panel as shown in the web page you indicated,
> instead of DOS which apparently does not keep the changes (I may have
> limited admin rights).
>
>
>
> Thank you very much for your support.
>
>
>
> Dominique
>
>
>
> *From:* Anthony Tuininga [mailto:ant...@gm...]
> *Sent:* vendredi 14 avril 2017 17:03
> *To:* cx-...@li...
> *Subject:* Re: [cx-oracle-users] DLL load failed
>
>
>
> Yes, installing Instant Client 12 will work for you. However, do not set
> ORACLE_HOME. On Windows you should simply put the location of OCI.DLL in
> your PATH environment variable. And in your case, ensure that it is before
> your other Oracle installation.
>
>
>
> This link gives the information on which Oracle client and server
> combinations are supported. It is part of the ODPI-C library which will be
> the underlying library used as of cx_Oracle 6.
>
>
>
> https://oracle.github.io/odpi/doc/installation.html#oracle-
> client-and-database-versions
>
>
>
> Anthony
>
>
>
> On Fri, Apr 14, 2017 at 1:48 AM, Dominique DEXHEIMER <
> dom...@to...> wrote:
>
> dependencywalker helped pinpoint the sore muscle, which is finding
> OCI.DLL. However it may just be a back compatibility issue. I have Oracle
> Client 10.2 while the oldest version of cx_Oracle is 11g.  I looked up
> previous posts for compatibility issues, but could not find anything
> helpful.
>
>
>
> My best bet is to install Instant Client 12 and give it precedence over
> the other client installed by pointing ORACLE_HOME to it.
>
>
>
> Thanks and regards,
>
> Dominique
>
>
>
> *From:* Massa, Harald Armin [mailto:ch...@gh...]
> *Sent:* jeudi 13 avril 2017 18:26
> *To:* cx-...@li...
> *Subject:* Re: [cx-oracle-users] DLL load failed
>
>
>
> Hi,
>
>
>
> I have run the installer cx_Oracle-5.2.1-12c.win-amd64-py2.7.exe on a
> Dell Precision T5610, running Windows7 64 bits, with apparent success: the
> compiled file cx_Oracle.pyd is in place under the site-packages directory.
> However, it seems that Python misses parts of the module (see session
>  below), even after appending a line to sys.path. Would there be another
> module registration to write somewhere before running it ?
>
>
>
> >>> import cx_Oracle
>
>
>
> Traceback (most recent call last):
>
>   File "<pyshell#0>", line 1, in <module>
>
>     import cx_Oracle
>
> ImportError: DLL load failed: The specified module could not be found.
>
> >>>
>
>
>
> most likely you are missing the Oracle OCI libary in the fitting 12c
> version. They have to be downloaded and licenced with Oracle.
>
>
>
> Make sure cx_Oracle is able to find them, usefull things are:
>
> - have the bin directory in your path
>
> - have the oracle environment variables set correctly.
>
>
>
> Usefull tool to diagnose:
>
> http://www.dependencywalker.com/
>
>
>
> Cheers,
>
>
>
> Harald
>
>
>
>
>
>
>
>
>
> --
>
>
>
> GHUM GmbH
> Harald Armin Massa
> Spielberger Straße 49
> 70435 Stuttgart
> 0173/9409607
>
> Amtsgericht Stuttgart, HRB 734971
>
>
> ------------------------------------------------------------
> ------------------
> Check out the vibrant tech community on one of the world's most
> engaging tech sites, Slashdot.org! http://sdm.link/slashdot
> _______________________________________________
> cx-oracle-users mailing list
> cx-...@li...
> https://lists.sourceforge.net/lists/listinfo/cx-oracle-users
>
>
>
> ------------------------------------------------------------
> ------------------
> Check out the vibrant tech community on one of the world's most
> engaging tech sites, Slashdot.org! http://sdm.link/slashdot
> _______________________________________________
> cx-oracle-users mailing list
> cx-...@li...
> https://lists.sourceforge.net/lists/listinfo/cx-oracle-users
>
>