Re: DLL load failed

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:[email protected]]
Sent: vendredi 14 avril 2017 17:03
To: [email protected]
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 <[email protected]<mailto:[email protected]>> 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:[email protected]<mailto:[email protected]>]
Sent: jeudi 13 avril 2017 18:26
To: [email protected]<mailto:[email protected]>
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
[email protected]<mailto:[email protected]>
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-oracle-users-5NWGOfrQmneRv+LV9MX5uipxlwaOVQ5f@public.gmane.org
https://lists.sourceforge.net/lists/listinfo/cx-oracle-users